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
|