| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| View the code in a add-in | Excel Worksheet Functions | |||
| How do you view an active macro code? | Excel Discussion (Misc queries) | |||
| View Code question | Excel Discussion (Misc queries) | |||
| Help! Lost sheets by using View Code on worksheet tab | Excel Discussion (Misc queries) | |||
| Need 2 add second then third code with first code in the Tab View | Excel Worksheet Functions | |||
Linear Mode
