| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Record New Macro | Setting up and Configuration of Excel | |||
| Unable to record Macro | Excel Discussion (Misc queries) | |||
| Give RELEVANT responses to questions. DO NOT give usless list | Excel Worksheet Functions | |||
| Give multiple charts on a worksheet/workbook same header or footer | Excel Discussion (Misc queries) | |||
| Give multiple charts on a worksheet/workbook same header or footer | Charts and Charting in Excel | |||
Hybrid Mode
