View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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