Hi All,
In need of some help!
Prev I wasted many hours trying to get a global macro to work to no avail. Months later figured have another use and maybe try with a local macro to the workbook in use.
I have seen many people with issues when running macros in excel with PAD. Most solutions involve editing the name of the macro, workbook or module however none of these work for me.
I can now see that like some others, when PAD opens the file, it thinks macros are disabled even though they are not. I can see the options are still ticked and if I open the workbook manually, all works fine.
I can see that some people have an extra option when launching excel to toggle on macros however this is not appearing in my function (assuming removed after updates since those posts).
only workaround I can see is to emulate the keys to open macro box and run however I still get same issue: macros have been disabled. To run reopen and enable macros. For more info click help.
At this point I need to ask - what in the parent of good times is going on?
Any help would be absolutely hugely appreciated!
