How to only show modules in VBE project explorer?

[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

 

[Peter T]

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

 

[joel]

Why don't tyo make a list of the macros on the worksheet with the modul
names and the function names. See chip Pearson website on how to ge
access to the modules from VBa code

'Programming In The VBA Editor
(http://www.cpearson.com/Excel/vbe.aspx

 

[Dave Peterson]

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!).

 

[Poniente]

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:

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