This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
In Excel 2003, I can get to the workbook code area directly from the Excel window just by right-clicking the tiny Excel icon just to the left of File on the menu bar and picking View Code.
Is there an equally easy way in Excel 2007?
I have been opening the VBE and going to the workbook code area from there.
gsnu201004
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
The only way I have found is to change the workbooks window state from "full view" to "normal view" (so the workbook is displayed as a child window)... then the icon you are referring to will be in the upper left corner of the floating window.
Answer accepted by question author
That is still possible in 2007; if the window is restored and the icon visible..
Thanks!
gsnu201005
There is also a View Code button that can be added to the Quick Access Toolbar. It is not quite the same as the using the Right Click method that Rick mentions, which takes you to the Visual Basic Editor with the This Workbook code pane having focus as when you use the View Code button on the Quick Access Toolbar, it is the code pane for the sheet that was active when the button was clicked that has the focus.
-- Hope this helps.
Doug Robbins - Word MVP,
dkr[atsymbol]mvps[dot]org
Posted via the Community Bridge
"Gary's Student" wrote in message news:*** Email address is removed for privacy ***...
In Excel 2003, I can get to the workbook code area directly from the Excel window just by right-clicking the tiny Excel icon just to the left of File on the menu bar and picking View Code.
Is there an equally easy way in Excel 2007?
I have been opening the VBE and going to the workbook code area from there.
-- gsnu201004
Doug Robbins - Word MVP dkr[atsymbol]mvps[dot]org
Add the Visual Basic item (from the All Commands Group) to the Quick Access Toolbar.
-- Hope this helps.
Doug Robbins - Word MVP,
dkr[atsymbol]mvps[dot]org
Posted via the Community Bridge
"Gary's Student" wrote in message news:*** Email address is removed for privacy ***...
In Excel 2003, I can get to the workbook code area directly from the Excel window just by right-clicking the tiny Excel icon just to the left of File on the menu bar and picking View Code.
Is there an equally easy way in Excel 2007?
I have been opening the VBE and going to the workbook code area from there.
-- gsnu201004
Doug Robbins - Word MVP dkr[atsymbol]mvps[dot]org