thefrasers
Board Regular
- Joined
- Aug 29, 2007
- Messages
- 58
For reasons I cannot fathom, my personal macros, which were nicely assigned to buttons on my toolbar and which did really difficult things like toggling between manual and auto calc, no longer seem to work. I have a macro worksheet in the xlstart folder, but the macros on the command bar become assigned to a directory reference rather than the open worksheet. Consequently, it tells me the worksheet is already open and it won't run the macro. I have no idea why this is now happening since it never used to. I can get the macros to work by terminating the hidden worksheet or by manually reassigning but this seems rather bizarre and is a real pain.
Instead of simply referring to the PMAC.xls macro (my personal macro) worksheet, when I examine each button the macro source has some reference like...
'C:\PROGRA~1\MICROS~2\Office10\xlstart\PMAC.XLS'!ToggleCalc
I can reassign the macros to the open worksheet, but then after I reopen later, the same problem reoccurs. Can anyone let me know what's going on, and even better why its changed?
Cheers.
Peter
Instead of simply referring to the PMAC.xls macro (my personal macro) worksheet, when I examine each button the macro source has some reference like...
'C:\PROGRA~1\MICROS~2\Office10\xlstart\PMAC.XLS'!ToggleCalc
I can reassign the macros to the open worksheet, but then after I reopen later, the same problem reoccurs. Can anyone let me know what's going on, and even better why its changed?
Cheers.
Peter