How to only show modules in VBE project explorer?
 

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

How to only show modules in VBE project explorer?
 

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

"Poniente" wrote in message
...
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

How to only show modules in VBE project explorer?
 

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

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


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=147658

How to only show modules in VBE project explorer?
 

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 wrote:

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

--

Dave Peterson

How to only show modules in VBE project explorer?
 

On 25 okt, 14:58, Dave Peterson wrote:
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!).

Ponientewrote:

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,
IlPoniente

--

Dave Peterson

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