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.
|