View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default Common Functions and Subs

Add the coding to you personal.xls file in your XLSTART folder.
--
Gary's Student


"rbnorth" wrote:

I have a set of common VBA Functions and Subs that are used in several (six)
Excel files. If I change / tweak a procedure in one file I have to change it
in all the other files. Is there a way to set up common modules that are
referenced by all the files? Then I only have to work with one set of
procedures