Making My Macros Stick.

[Mr Nick]

How do I ensure that when I do a 'Save As' on my worksheet, all the associated macros will be bound with it?

At the moment, every time I 'Save As' and then press a tool button to activate one of my macros, I get either an error message staing that the path cannot be found or the original worksheet opens and the macro is executed on the original copy.

 

[Dave Hawley]

Hi Nick


You say "them", are you referring to the buttons or your Custom toolbar? I mean the latter.


Ok, just saw your post! :0


_________________
Kind Regards
Dave Hawley
OzGrid Business Applications
Microsoft Excel/VBA Training

This message was edited by Dave Hawley on 2002-04-09 07:55