G
Guest
Hi there,
I have a number of macros that I want to be activated in a series by
attaching them all to one 'button' on the work sheet they relate to.
That works fine to start with but because the workbook will be opened and
then saved with a different name by users, the "Application run ......xls
..Sheet13."macroname" approach means an error message about not finding the
macro. How do I code this so that the macros can be found whatever the user
names the book after opening it.
Thanks
Sybs
I have a number of macros that I want to be activated in a series by
attaching them all to one 'button' on the work sheet they relate to.
That works fine to start with but because the workbook will be opened and
then saved with a different name by users, the "Application run ......xls
..Sheet13."macroname" approach means an error message about not finding the
macro. How do I code this so that the macros can be found whatever the user
names the book after opening it.
Thanks
Sybs