thefrasers
06-02-2008, 11:57 AM
INITIAL admission - this is crossposting. I couldn't get a reply on the Mr Excel message board & so I'm trying here - is that okay? If not ignore below...
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 properly. If I use the 'Open Office Document' dialog box then even though I have a macro worksheet in the xlstart folder, the macros on the command bar become assigned to a directory reference rather than the open worksheet. Consequently, Excel 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
As a quick fix, I can reassign the macros to the open worksheet, but then after I close and reopen later, the same problem reoccurs. Even more bizarrely, If I open a workbook using the 'New Office Document' dialog box (load a blank worksheet and then load the one I want to work on), then the Macros work fine.
Can anyone let me know what's going on, and even better why its changed?
Cheers.
Peter
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 properly. If I use the 'Open Office Document' dialog box then even though I have a macro worksheet in the xlstart folder, the macros on the command bar become assigned to a directory reference rather than the open worksheet. Consequently, Excel 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
As a quick fix, I can reassign the macros to the open worksheet, but then after I close and reopen later, the same problem reoccurs. Even more bizarrely, If I open a workbook using the 'New Office Document' dialog box (load a blank worksheet and then load the one I want to work on), then the Macros work fine.
Can anyone let me know what's going on, and even better why its changed?
Cheers.
Peter