On Wed, 21 Dec 2005 19:46:39 -0600, "42N83W"
wrote:


"Hexman" wrote in message
.. .
I assume any public code that is common to the entire workbook. Isn't
"ThisWorkBook" just the same as a user-added module?

Please set me straight on the use of "ThisWorkBook" vs Modules.

Thanks,

Hexman


The ThisWorkbook code module is a good place to put menu creation and
deletion code and variable initiation code. If you put code like this in
the ThisWorkbook code module for your PERSONAL.XLS file, you can load all
sorts of customizations and menus when the app starts. The only two events
in this module that I currently utilize are the Workbook_Open event the
Workbook_Close event.

Thanks,

Hexman