sheet1 vs ThisWorkBook

[Ben]

Hi,

Doe sit matter where you stick a macro using the visual basic editor?
There is for example sheet1 and something else called "ThisWorkBook"?

Thanks,
Bn

 

[J.E. McGimpsey]

Yes. Both ThisWorkbook and SheetX modules are special class modules
associated with their respective objects (the workbook and the
worksheet). They normally should be reserved for Event Macros only.
For regular macros, use Insert/Module to insert a regular code
module.

See

http://cpearson.com/excel/codemods.htm

or

http://www.mcgimpsey.com/excel/modules.html

for more explanation.

 

[Ben]

See

http://cpearson.com/excel/codemods.htm

or

http://www.mcgimpsey.com/excel/modules.html

for more explanation.

Thanks! I took a glance at the first link and already see that it will
extremely useful.

Thanks again!
Ben