Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to launch VBA in 2007
I am new to excell 2007... I am trying to unlock passwork protected modules
and don't know how to launch VBA (since I cannot step into a locked macro). Second... any suggested reading to update me on excell and VB 2007? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to launch VBA in 2007
start excel
click the office button click on excel options at the bottom check the box to show the developer tab on the ribbon once you click that, you should be fine -- Gary Keramidas "John" wrote in message ... I am new to excell 2007... I am trying to unlock passwork protected modules and don't know how to launch VBA (since I cannot step into a locked macro). Second... any suggested reading to update me on excell and VB 2007? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to launch VBA in 2007
You can "launch" the VBA Editor with ALT F11. This will open the editor, and
on the left side of the screen should be the "Project Explorer" window that lists all open workbooks. If a workbook's VBProject is not protected, you can click the '+' symbol next to it to open things up. If the project is protected, you can't open the VBA for that workbook. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "John" wrote in message ... I am new to excell 2007... I am trying to unlock passwork protected modules and don't know how to launch VBA (since I cannot step into a locked macro). Second... any suggested reading to update me on excell and VB 2007? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to launch VBA in 2007
Alt+F11 still gives access to the VB Editor.
For some voluminous background on the new User Interface in Office 2007, you might want to peruse Jensen Harris' (Jensen is the program manager in charge of the Office UI team) blog which has been indexed by Patrick Schmid at: http://pschmid.net/blog/2006/10/09/58 HTH |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to launch VBA in 2007
Thanks to one and all!
"JeffreyW" wrote: Alt+F11 still gives access to the VB Editor. For some voluminous background on the new User Interface in Office 2007, you might want to peruse Jensen Harris' (Jensen is the program manager in charge of the Office UI team) blog which has been indexed by Patrick Schmid at: http://pschmid.net/blog/2006/10/09/58 HTH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to launch Excel 2007 in Maximized state every time | Excel Discussion (Misc queries) | |||
2007 Excel will not launch from file | Excel Discussion (Misc queries) | |||
How do I set the default Excel app. to launch (2003 vs 2007)? | Excel Discussion (Misc queries) | |||
How to launch one XLA from another on Excel launch | Excel Programming | |||
Macro launch - Button vs Manual launch , has different results. | Excel Programming |