ThisWorkbook module

  • Thread starter Thread starter Sahak
  • Start date Start date
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Programatically adding macro to Excel - "ThisWorkbook" 3
Running a macro from windows application 1
Public variables 2
Document not saved at the end of macro 1
Excel Providing user message when RED X clicked & properly closing application. 2
Grouping Function on protected sheet 1
2007 View Code ThisWorkbook 2
Workbook with macro unvisable in VBE 3

Back
Top