Toolbar Buttons and Macros available always

[Jerry]

I've received some great help here and I made a couple
macros and assigned them to a button on the toolbar. They
work great in the file I wrote them in.

When I open another existing spreadsheet, the buttons are
there, but the macros aren't, so I get an error.

How do I make those macros available to all documents,
both existing and future? Similar to how Word's
normal.dot template works.

Thanks in advance.

Jerry

 

[Township of East Hanover]

drop the file with the buttons and macros into the XLStart folder and it
will load each time excel opens.

 

[David McRitchie]

Hi Jerry,
Really a matter of having macros available in any workbook.
Create a personal.xls workbook in your XLSTART directory.

You can let excel do this for you by recording a macro and
using the personal.xls button when you name the macro.
Place the macros that you want to be available at all times
in your personal.xls -- you can use another name for the
workbook if you want but Excel makes it easier for you to
use the conventional personal.xls filename.

When you hide (window, hide within Excel) your personal.xls
the macros will be available to all workbooks.
http://www.mvps.org/dmcritchie/excel/getstarted.htm

In the reply that "Township of " just posted, you do not want to
put your workbooks into the XLSTART directory, just the macros.
Anything in your XLSTART directory will be started with Excel and
if you have normals workbooks opening up you will create yourself
one big problem.

 

[Jerry]

Thanks, David, you taught me a lot!

Jerry