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.


Brian Murphy
Austin, Texas

Chip Pearson

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

Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
(email address is on the web site)

Zack Barresse

Hello there,

No keyboard shortcut to hide the Project Explorer window. Sorry. Although,
you can do so via code...


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 - " &

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
End Sub


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question