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

  • Thread starter Thread starter cj
  • Start date Start date
C

cj

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
 
Back
Top