Custom Menu Problems with Macros
Posted by Christopher Patrick on August 28, 2001 10:30 AM
If someone can help me out, I would greatly appreciate it. I have a custom toolbar, with custom buttons all tied to macros. When I created the buttons and macros, I selected the "This Workbook" option from the "Macros in" dialogue. It seems that if I copy the file and rename it though, that it continually has attatched the previous file name to the macro, and to run the macro, it must first open my original file...is there anyway to tell the buttons to only run the macros in their own workbook, and stay with those settings?