View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SYBS SYBS is offline
external usenet poster
 
Posts: 31
Default application run - macros within macros

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