Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
is it possible to toggle display of project window with control-R
Dear Group,
In the VBA IDE is there a keyboard shortcut that will toggle the display of the VBA project window? Control-R displays this windows, but doesn't hide it, which is unfortunate. For example, in the MZTools 3.0 VBA-IDE utility one can enable keyboard toggles for the Watch and Locals windows, but evidently not for the Project window or Immediate window. Thanks, Brian Murphy Austin, Texas |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
is it possible to toggle display of project window with control-R
I don't think there is a shortcut key defined to do this. The code to do it
would be Dim ActiveProj As Object Set ActiveProj = Application.VBE.ActiveVBProject If Not ActiveProj Is Nothing Then Application.VBE.Windows("Project - " & ActiveProj.Name).Visible = False End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) wrote in message ups.com... Dear Group, In the VBA IDE is there a keyboard shortcut that will toggle the display of the VBA project window? Control-R displays this windows, but doesn't hide it, which is unfortunate. For example, in the MZTools 3.0 VBA-IDE utility one can enable keyboard toggles for the Watch and Locals windows, but evidently not for the Project window or Immediate window. Thanks, Brian Murphy Austin, Texas |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
is it possible to toggle display of project window with control-R
Hello there,
No keyboard shortcut to hide the Project Explorer window. Sorry. Although, you can do so via code... Application.VBE.Windows(2).Close There are other windows you can use as well... 1: Module1 (Code) *2: Project - VBAProject 4: Properties - Module1 5: Object Browser 6: Watches 7: Locals 8: Immediate * Followed by all modules, then class modules, then userforms. So the numbers will change depending on how many variables you have. The first example above is with only one standard code module, hence the number two. You can use the "Properties - VBAProject" name for a string syntax. If you have changed the name you can use the following.. Application.VBE.Windows("Project - " & Application.VBE.ActiveVBProject.Name).Close To view a list of what you have, use ... Sub showVBEwindows() Dim i As Long For i = 1 To 100 On Error GoTo TheEnd Debug.Print i & ": " & Application.VBE.Windows(i).Caption Next i TheEnd: End Sub HTH -- Regards, Zack Barresse, aka firefytr wrote in message ups.com... Dear Group, In the VBA IDE is there a keyboard shortcut that will toggle the display of the VBA project window? Control-R displays this windows, but doesn't hide it, which is unfortunate. For example, in the MZTools 3.0 VBA-IDE utility one can enable keyboard toggles for the Watch and Locals windows, but evidently not for the Project window or Immediate window. Thanks, Brian Murphy Austin, Texas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Docking Project Explorer, Properties window and Code window in VBE | Setting up and Configuration of Excel | |||
Shortcut Menu With Toggle Control | Excel Programming | |||
Project still in "project explorer" window after file closed down! | Excel Programming | |||
Project still in "project explorer" window after file closed down! | Excel Programming | |||
Toggle Control & Formula | Excel Programming |