View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RSS[_2_] RSS[_2_] is offline
external usenet poster
 
Posts: 2
Default best way to set up macro library so all spreadsheets have access?

Hi,

I have lots of different macros recorded in different spreadsheets. Is
there a way to create a macro library so all of my spreadsheets would have
the same access to all of my macros?

It would br great if I could group macros by subject content e.g.
statistical macros, logic macros, movement macros, etc and then be able to
load the groups that I need for a given spreadsheet.

I'm just not sure how to set this up. I have a basic macro recorded and it
seems like when I do these they become part of the current spreadsheet. The
only way I can reuse the macro is to copy it into the new spreadsheet or I
think, have the old spreadsheet opened in the background.

Does this make any sense? There's got to be a better way