View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Using the same macro on different sheets

As always, post YOUR macro for comments


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Beverly Darvill" wrote in message
...
I have a number of worksheets that employ the same macro and on occasions I
need to update the information with the macro. To stop having to repeat
the
information a number of times I want to store all the macros in one sheet
so
that I only have to update the information once. However I don't want the
sheet that holds the macro to open everytime and then have to close it
everytime. Is this possible? If so how

Thanks Beverly