VBE clutter
-
VegasNath
- 5StarLounger
- Posts: 1185
- Joined: 24 Jan 2010, 12:02
- Location: Wales, UK.
VBE clutter
Some of my workbooks have large volumes of modules. Is there a way to hide modules or add folders within the modules tree?
Nathan 
There's no place like home.....
-
HansV
- Administrator
- Posts: 78565
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
VegasNath
- 5StarLounger
- Posts: 1185
- Joined: 24 Jan 2010, 12:02
- Location: Wales, UK.
Re: VBE clutter
HansV wrote:No, sorry.
Thought not, but it amazes me why this is not possible. No add-ins? 
Thanks anyway. Nathan There's no place like home.....
-
HansV
- Administrator
- Posts: 78565
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
Goshute
- 3StarLounger
- Posts: 397
- Joined: 24 Jan 2010, 19:43
- Location: Salt Lake City, Utah, USA
Re: VBE clutter
If any modules are less than about 500 lines of code you could combine them. In Excel 97-2003 workbooks, even blank modules increased the size of the workbook, not sure if that's still true with the new formats.
Goshute
I float in liquid gardens
I float in liquid gardens
-
Jezza
- 5StarLounger
- Posts: 847
- Joined: 24 Jan 2010, 06:35
- Location: A Magic Forest in Deepest, Darkest, Kent
Re: VBE clutter
I don't know how practical this is due to the amount and if you use "reuasable" functions but have you thought of storing your functions in XLA format?VegasNath wrote:Some of my workbooks have large volumes of modules. Is there a way to hide modules or add folders within the modules tree?
Jerry
I’ll be more enthusiastic about encouraging thinking outside the box when there’s evidence of any thinking going on inside it
I’ll be more enthusiastic about encouraging thinking outside the box when there’s evidence of any thinking going on inside it