Thread: Macro template
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
zkid zkid is offline
external usenet poster
 
Posts: 6
Default Macro template

I do most of my VBA programming in Word. I can create a template with
macros and save it to the Office Startup directory. The macros are
availalble to Word but are not stored in each new document.

I need to do the same thing in Excel. However, If I use the XLStart
directory and save macros in Book.xlt, all new spreadsheets will also contain
the macros/toolbars. I just want the macros to be available to Excel, not
stored in each new spreadsheet. Is the only way to do this through an
add-in? And, if so, it has to be registered through the registry? Isn't
there an easier way to share macros for numerous users?

Thanks for any help you can provide.