Michael 514
03-07-2005, 09:32 AM
Hi there!
How is that for an archaic title to this thread?
I did a cursory search here, but cannot locate an answer to what is probably a simple question.
I have created some macros in Excel (I confess -- keystroke macros, not VBA coding...).
Anyway, I dragged them up to the button bar.
Everything works fine, until I rename the Excel file.
Correct me if I am wrong, but it appears as though Excel adds the filename before the macro name in the Toolbar.
Therefore, the minute I rename my document, the macro cannot be found anymore.
Does anyone know what I am talking about?
Is there a simple work-around?
Ideas are welcome!!
Thanks!
Mike
How is that for an archaic title to this thread?
I did a cursory search here, but cannot locate an answer to what is probably a simple question.
I have created some macros in Excel (I confess -- keystroke macros, not VBA coding...).
Anyway, I dragged them up to the button bar.
Everything works fine, until I rename the Excel file.
Correct me if I am wrong, but it appears as though Excel adds the filename before the macro name in the Toolbar.
Therefore, the minute I rename my document, the macro cannot be found anymore.
Does anyone know what I am talking about?
Is there a simple work-around?
Ideas are welcome!!
Thanks!
Mike