View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
crapit crapit is offline
external usenet poster
 
Posts: 75
Default How to make macro available to all workbook w/o opening VBA

Is it mandatory to have the filename PERSONAL.XLS ?
"Mike Fogleman" wrote in message
...
Store your macros in a file named PERSONAL.XLS. Save that file in your
XLSTART folder. From then on when you open Excel that workbook will be
opened also, but in a Hidden Window. The Macros will be listed when you
open Tools/Macros.

Mike F
"crapit" wrote in message
...