The macro "C:\...\Desktop\PERSONAL.XLS'!Macro_Filename' cannot be found.

[Mike Welch]

I have a custom button that worked fine until I saved PERSONAL.XLS to the desktop so that I could easily send it off in an email (with it's specialized macros). Now when I press the formerly working button I get the message in the header. MS has, in it's wisdumb, apparently told Excel to look for PERSONAL.XLS on the desktop (which has been deleted) and I can't find a way to tell it to go look in C:\Documents and Settings\user\Application Data\Microsoft\Excel\XLSTART where it belongs (right???). Any help appreciated!

Win XP Pro SP3 / Excel 2003 SP3

 

[Mike Welch]

There isn't unfortunately. I wrote this ages ago when our IT department started messing up our network drives - it may help you (the first filepath is the old, incorrect one, the second is the new one you want used):

Rory - that was EXACTLY what I wanted and it worked perfectly. Thanks very much!

Mike