| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Share Macro
I created a macro in Office 2007 and need to know how to use this macro in
all worksheets? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Share Macro
If the macro is written to use the activesheet, then you can just activate any
worksheet and run the macro. If you meant that you want the macro available for all workbooks (different files)... Macros live in workbooks. So open the workbook that contains the macro. Open the workbook that needs to have the macro run against it. Activate the correct worksheet in that workbook. Hit alt-f8 to get to the macro dialog. Select your macro and run it. Sarah wrote: I created a macro in Office 2007 and need to know how to use this macro in all worksheets? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Share a macro | New Users to Excel | |||
| Can I share a selfcert macro workbook with other network users | Excel Discussion (Misc queries) | |||
| I recorded a macro, how can i share it with others? | Excel Worksheet Functions | |||
| How to Share & "Un-Share" Worksheets | Excel Worksheet Functions | |||
| How can I share a macro with other users in the network within a . | Excel Worksheet Functions | |||
Linear Mode
