Microsoft Office Tutorials and References
In Depth Information
Opening Worksheet Objects (Excel)
Figure 111 – Opening Excel Worksheet Object
You will be presented with a list of all the sheets in the workbook, as shown
below. To activate the code pane of a specific sheet, either right-click it and
choose View Code from the menu, or double-click the sheet.
Tip: If you are in the main Excel screen, you can open up the Visual Basic Editor at the correct
sheet module by right-clicking the sheet tab and choosing View Code from the menu!
Figure 112 – Viewing Worksheet Code