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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sending a macro to another person 1
Vista problem with NO Personal Macro Workbook in Startup Folder 6
Macro to push data to another workbook 0
Cannot find Personal Macro Workbook 2
saving macro from workbook to Personal Macro Workbook 1
Personal Macro Workbook in startup folder missing 3
Multiple Workbooks using same macro 4
Macros 6

Back
Top