Record a macro to use in any workbook--give it to others.
 

I can record a macro that does what I want fine but I don't really
understand the options on where to save the macro. Personal Macro
Workbook, New Workbook, This Workbook. Since I'm recording this to give
to some other folks to use on their own spreadsheets I can't see storing
it in This Workbook.

How would I store it and how would I pass it on to someone?

How would they get it to be available whenever they opened Excel on
their computer?

I'm using Excel 2000

Thanks

Record a macro to use in any workbook--give it to others.
 

Hi CJ

You can use a add-in

See Dave's example on Debra's site
http://www.contextures.com/xlToolbar02.html

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"cj" wrote in message ...
I can record a macro that does what I want fine but I don't really
understand the options on where to save the macro. Personal Macro
Workbook, New Workbook, This Workbook. Since I'm recording this to give
to some other folks to use on their own spreadsheets I can't see storing
it in This Workbook.

How would I store it and how would I pass it on to someone?

How would they get it to be available whenever they opened Excel on
their computer?

I'm using Excel 2000

Thanks