Macro location

[John P]

Hello everyone,

In order to allow a macro to be actionable throughout a workbook (from every
sheet).

Where is the best place to store the code?

In Modules, Sheets or some other common area like ThisWorkbook?

Thanks in anticipation.


John
N. Yorks UK

 

[Jack Schitt]

Most macros will be placed in general modules. They will be accessable
whatever is the active worksheet, provided you do not define them as
"Private" subs.

For very specific reasons you may want to put some macros in specific class
modules, such as the ThisWorkbook or behind particular sheets, but you would
generally have a specific reason for doing this.

 

[John P]

Thank you.

John

Most macros will be placed in general modules. They will be accessable
whatever is the active worksheet, provided you do not define them as
"Private" subs.

For very specific reasons you may want to put some macros in specific
class
modules, such as the ThisWorkbook or behind particular sheets, but you
would
generally have a specific reason for doing this.