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.
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.