2007 View Code ThisWorkbook
 

In Excel 2003, we could easily right-click the Excel icon in the menu bar
(next to File etc.) and select "View Code" to go straight to the
"ThisWorkbook" object in the VBA Editor. Is there any similar shortcut
available for this in Excel 2007 that I could perhaps add to my Quick Access
Toolbar? Or perhaps a keystroke combination similar to Alt+F11 that would
take you straight to ThisWorkbook? Thanks!
--
Please remember to indicate when the post is answered so others can benefit
from it later.

2007 View Code ThisWorkbook
 

Hi,
right click in the tab name

"KC" wrote:

In Excel 2003, we could easily right-click the Excel icon in the menu bar
(next to File etc.) and select "View Code" to go straight to the
"ThisWorkbook" object in the VBA Editor. Is there any similar shortcut
available for this in Excel 2007 that I could perhaps add to my Quick Access
Toolbar? Or perhaps a keystroke combination similar to Alt+F11 that would
take you straight to ThisWorkbook? Thanks!
--
Please remember to indicate when the post is answered so others can benefit
from it later.

2007 View Code ThisWorkbook
 

Thanks, but that does not take you straight to the "ThisWorkbook" object.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Eduardo" wrote:

Hi,
right click in the tab name

"KC" wrote:

In Excel 2003, we could easily right-click the Excel icon in the menu bar
(next to File etc.) and select "View Code" to go straight to the
"ThisWorkbook" object in the VBA Editor. Is there any similar shortcut
available for this in Excel 2007 that I could perhaps add to my Quick Access
Toolbar? Or perhaps a keystroke combination similar to Alt+F11 that would
take you straight to ThisWorkbook? Thanks!
--
Please remember to indicate when the post is answered so others can benefit
from it later.