View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BitTwiddler BitTwiddler is offline
external usenet poster
 
Posts: 1
Default VBA code shared between .XLS files

I have lots of worksheet files that use the same VBA code. Currently I copy
the code from one file to the next. However, if there is an error in the VBA
code, I have to go to ALL the files and update it, which is a royal pain.
Combining all the files into a single file is not practical. How can I have
a single copy of the VBA code that is used by all the files?
--
John