Custom Toolbar Buttons

[markf5998]

I created a custom toolbar with a custom button on it and it worked for a few days. Now, when I try to use it, I get an error that says "Book1.xls cannot be found".

I assume it is looking for the macro that was assigned to the button.

Can someone please tell me where to save the macro so that it is always available in any xls file? Also wierd that it worked for a while then quit.

Thanks!!

 

[jeffreybrown]

You should save it to your personal macros.

What version of Excel are you using?

 

[markf5998]

I'm using 2003...but not sure where my personal macros are stored!

 

[jeffreybrown]

Hi Mark,

Take a look at this which explains it much better than I can.

http://www.rondebruin.nl/personal.htm

 

[markf5998]

Thanks, greatly appreciated!