Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |