View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Issue with Toolbar Menu

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" wrote in message
...
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,
Arnold