is it possible to toggle display of project window with control-R

[bmurphy]

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

 

[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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(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...

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