View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
joecrabtree joecrabtree is offline
external usenet poster
 
Posts: 111
Default Run Macro in one worksheet from a button on another worksheet

To all,

I have written a macro that does various things in a worksheet called
DATA. At the moment I am running in by using a button in this
worksheet, so that when the user clicks it, it runs.

However I wish to place a button on the main worksheet called WELCOME
and to run the macro in the DATA spreadsheet. Is it possible to do this
without rewriting the macro that I have in the DATA worksheet?

Thanks in advance,

Regards

Joseph Crabtree