How to only show modules in VBE project explorer?

  • Thread starter Thread starter Poniente
  • Start date Start date
P

Poniente

My VBE project explorer displays for each workbook all the modules,
references and sheets. This is a long list. Most of the time, I'm only
interested in the modules. Is there a way to group all the sheets and
references and make them only visible when you expand them by clicking
on a 'plus' sign?

Many thanks in advance,
Il Poniente
 
Ensure you close all module windows in the project and fully collapse tree
in project explorer before you save the workbook. When you switch to the VBE
the tree of sheet modules will be expanded with the activesheet's code
module highlit. However only the activeworkbook will have that section of
the tree expanded. That's the best you can do.

Regards,
Peter T
 
If I understand correctly...

Open the VBE
Show the project explorer (ctrl-r)
At the top of that window (just under the window's titlebar) are three icons.

View code, view objects and Toggle Folders.

Click that rightmost icon.

=====
ps. if you have lots of workbooks open and you don't like seeing their projects
in the VBE's project explorer window, you can password protect that project (but
remember that password!).
 
If I understand correctly...

Open the VBE
Show the project explorer (ctrl-r)
At the top of that window (just under the window's titlebar) are three icons.

View code, view objects and Toggle Folders.

Click that rightmost icon.

=====
ps.  if you have lots of workbooks open and you don't like seeing theirprojects
in the VBE's project explorer window, you can password protect that project (but
remember that password!).

Ponientewrote:
Click to expand...

Hi Dave,
That was exactly what I was looking for.
Thanks a lot, highly appreciated!
IlPoniente
 
Back
Top