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