Salsasteve
06-28-2009, 01:42 AM
When I save my project to a memory stick, excel changes the macros assigned to my toolbar buttons by adding the pathname of the memory stick.
Running the file from the memory stick is okay, but from the C drive, the macros retain the association with the memory stick, even if I do a "save as" to the C drive.
I have to go to Tools/customize and reset all the assignments manually to put it right. Similarly, when I transfer the file to the desktop at work, I have to manually re-assign the macros.
However, if I delete the file on C, open it from the memory stick and then save it to C, the buttons work okay, but the filename (without the path) has been added to the macro names!
How can I get excel to use the macros in the currently open workbook, so that the pathname is irrelevant?
Any help would be appreciated!
Steve
Running the file from the memory stick is okay, but from the C drive, the macros retain the association with the memory stick, even if I do a "save as" to the C drive.
I have to go to Tools/customize and reset all the assignments manually to put it right. Similarly, when I transfer the file to the desktop at work, I have to manually re-assign the macros.
However, if I delete the file on C, open it from the memory stick and then save it to C, the buttons work okay, but the filename (without the path) has been added to the macro names!
How can I get excel to use the macros in the currently open workbook, so that the pathname is irrelevant?
Any help would be appreciated!
Steve