I created a custom menu with options to trigger macros. The only problem is however, excel is automatically converting these to (xlFilename)!(MacroName). They run fine in that file, but whenever I run the report for the file, and save for that daily version, the macro links still refer to the original file and I do not want the original file to be opened by excel just to run simple navigational macros.

At first I was just going to make these standalone macros, however, the end user will not have access to this directory.

Is there ANY possible way to make excel link to (MacroName) rather than including the filename, and not try to update this link when it is saved as a new file.

Just to note, this toolbar is attached to the worksheet.

Let me know if anyone can help!