sheet1 vs ThisWorkBook

Ben · Dec 21, 2003

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 · Dec 21, 2003

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 · Dec 21, 2003

J.E. McGimpsey said:
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