LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA project duplicated in Project Explorer teabag Excel Programming 11 December 27th 17 11:13 AM
XLA addin attached in settings does not show up in project explorer Leon[_2_] Excel Discussion (Misc queries) 0 June 10th 09 08:03 AM
XLA addin attached in settings does not show up in project explorer Leon[_2_] Excel Discussion (Misc queries) 0 June 8th 09 12:48 PM
My VBA Project Explorer quit listing modules and worksheets separa TomThumb Excel Programming 1 September 2nd 08 09:05 PM
Project still in "project explorer" window after file closed down! Gunnar Johansson Excel Programming 16 December 22nd 04 06:21 PM


All times are GMT +1. The time now is 11:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"