Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA project duplicated in Project Explorer | Excel Programming | |||
XLA addin attached in settings does not show up in project explorer | Excel Discussion (Misc queries) | |||
XLA addin attached in settings does not show up in project explorer | Excel Discussion (Misc queries) | |||
My VBA Project Explorer quit listing modules and worksheets separa | Excel Programming | |||
Project still in "project explorer" window after file closed down! | Excel Programming |