View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arnold Dubin Arnold Dubin is offline
external usenet poster
 
Posts: 1
Default Can't Move Menu with Macros to Another Folder

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