ThisWorkbook module

S

Sahak

Hi,

Please help me to understand if it says "Put this code in
the ThisWorkbook module. Where is the ThisWorkbook
module, or how make it?

Thank you in advance
Sahak
 
M

Myrna Larson

If you go to the VB Editor (ALT+F11), you'll normally see the screen divided into 3 panes. The
one on the upper left is the Project pane. In it you'll see a tree-view of the open workbooks.
Expand the section for your workbook. Under Excel Objects there will be a module named
ThisWorkbook. Double click on it to display its code in the large code pane on the right. Paste
the code there.
 
Top