MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Cutomized Macro Button paths

Posted by Christopher Patrick on August 28, 2001 12:09 PM

Hi all-

If someone can help me out, I would greatly appreciate it. I am rewording a previous post of mine. I have a customized toolbar, with buttons I have attatched to macros. I have noticed that somehow Excel attatches the file and pathname of my workbook also to the macros. If I move my workbook, the buttons no longer work, until I update the path of the file for all macro buttons. Is there a way to attatch macros to buttons without path attatchment also? THanks.

Posted by Geoff on August 28, 2001 6:15 PM

Put the macros in Personal.xls (and put the file in the XLStart folder).

Posted by Ivan F Moala on August 28, 2001 10:40 PM

Use Geoffs suggestion OR

Create the buttons dynamically and make the
file an Addin.