Issue with Toolbar Menu

D

Dubin

I developed many Macro's and a VB Sub made a toolbar with multilevel menu and associated Macro s with them and I can't get them to work on Excel 2003 Spreadsheet when I move .xls file from my Deck Top (Windows XP Pro) folder to another folder on my PC or moving it to another PC. The menu seems to be transferring from folder to folder and PC to PC but not the Macro associated with that menu. I must re-associate each menu item with the Macro again. The error message I am receiving is "The Macro "C:\Documents and Settings\Arnold Dubin\Desktop\2004.XLS'!Print_Monthly_Report' cannot be found.

Can somebody help me solve this problem

Thanks
Arnol
 
T

Tom Ogilvy

You are correct that the path in the macro association is not adjusted
automatically. (as I understand the circumstances you describe).

--
Regards,
Tom Ogilvy

Dubin said:
I developed many Macro's and a VB Sub made a toolbar with multilevel menu
Click to expand...
and associated Macro s with them and I can't get them to work on Excel 2003
Spreadsheet when I move .xls file from my Deck Top (Windows XP Pro) folder
to another folder on my PC or moving it to another PC. The menu seems to be
transferring from folder to folder and PC to PC but not the Macro associated
with that menu. I must re-associate each menu item with the Macro again.
The error message I am receiving is "The Macro "C:\Documents and
Settings\Arnold Dubin\Desktop\2004.XLS'!Print_Monthly_Report' cannot be
found."
 
Top