How do i reuse a Excel macro on another worksheets, global macro?

[Guest]

I created a module/macro on one of the excel sheets. Now i want this to be
used in another worksheets. I do not want to end up copying modules, but is
there a concept of global macros?

 

[Nigel]

The simplest thing to do would be to save it in your personal macro
workbook.

If you have not created one already, then record a new macro and chose the
drop down store in 'Personal Macro Workbook'

A new workbook is created (default called Personal.xls), in the autoopen
directory of Excel, when you open Excel this workbook is also opened yet it
is hidden. Macros in the workbook can be run from the visible workbook.