in the development environment (ALT+F11)
from the Project Explorer, right click the ThisWorkbook
object and select View Code
- in fact double clicking it opens its code window.

A short-cut for this procedure (assuming you are *not* using XL2007) is to
right-click the XL icon immediately to the left of the File menu item and
select View Code... the VB editor will open up and you will be placed
directly inside the code window for ThisWorkbook.

--
Rick (MVP - Excel)