Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |