Thanks, Tom. I did see your other entry Add-ins, etc. But, what about
if I want to distribute this to other users? The site you provided in your
other response discouraged people from using the personal workbook, as it
would end up wiping out other people's settings

Any other ideas?

"Tom Ogilvy" wrote:

Use Personal.xls located in that directory (xlstart). Excel works
differently than word.

You can get excel to create it for you by recording an macro and selecting
to store it in the personal workbook.

--
Regards,
Tom Ogilvy


"zkid" wrote in message
...
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.