Share Macro

  • Thread starter Thread starter Sarah
  • Start date Start date
S

Sarah

I created a macro in Office 2007 and need to know how to use this macro in
all worksheets?
 
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.
 
You must log in or register to reply here.

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

activate/deactivate macro depending on who's the user 3
problem with macros and protections 5
2003 xla Add In Macro convert to 2007? 3
Runtime error 5
Problem (bug?) in the way Excel 2007 doesn't automatically load ma 8
help with macros in Excel 2007 1
Excel 2007: Help creating a macro that will run Solver? 3
sending a macro to another person 1

Back
Top