Microsoft Office Tutorials and References
In Depth Information
Opening ThisWorkbook Object (Excel)
Opening ThisWorkbook Object (Excel)
Open the VBE by hitting Alt+F11.
Using the Project Explorer, locate the project (file) you are working on. Click
the little + signs to drill down into the folder called Microsoft Excel Objects.
Figure 113 – Opening Excel ThisWorkbook Object
As shown in the example, you will be presented with a list of all the sheets in
the workbook. To activate the code pane for the ThisWorkbook object, either
right-click it and choose View Code from the menu, or double-click it.
Opening ThisDocument Objects (Word)
Open the VBE by hitting Alt+F11.
Using the Project Explorer, locate the project (file) on which you are working.
By clicking the little + signs, drill down into the folder called Microsoft Word
Objects.
Apx
 
Search JabSto ::




Custom Search