ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Project Elements as One List (https://www.excelbanter.com/excel-programming/275190-project-elements-one-list.html)

Pat Beck

Project Elements as One List
 
Excel 2002
WinXP

While I'm here asking a question ("Code in ThisWorkbook crashes Excel"),
I'll ask another real simple one (I think).

I've noticed lately that in my Project Explorer my modules, sheets, forms,
and ThisWorkbook all show up in alphabetical order in one list under the
project. Didn't it before contain forms in a form folder, modules in a
modules folder, etc.? Did I click something to do this or is that the way
v2002 is? Can I get it back the old way?

Thanks,
Pat



Rob Bovey

Project Elements as One List
 
Hi Pat,

Look along the top of the Project Window in the Visual Basic Editor and
you'll see three toolbar buttons (not on the main toolbar, but just below
the Project Window title bar). The third button is called Toggle Folders.
Click this button once to put your Project Window back to folder view.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Pat Beck" wrote in message
...
Excel 2002
WinXP

While I'm here asking a question ("Code in ThisWorkbook crashes Excel"),
I'll ask another real simple one (I think).

I've noticed lately that in my Project Explorer my modules, sheets, forms,
and ThisWorkbook all show up in alphabetical order in one list under the
project. Didn't it before contain forms in a form folder, modules in a
modules folder, etc.? Did I click something to do this or is that the way
v2002 is? Can I get it back the old way?

Thanks,
Pat





Pat Beck

Project Elements as One List
 
Yep, that was it! Thanks a bunch!!

And thanks for the Code Cleaner, too. <g I've been using it for a long
while and it's saved me many times.

Pat

"Rob Bovey" wrote in message
...
Hi Pat,

Look along the top of the Project Window in the Visual Basic Editor

and
you'll see three toolbar buttons (not on the main toolbar, but just below
the Project Window title bar). The third button is called Toggle Folders.
Click this button once to put your Project Window back to folder view.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Pat Beck" wrote in message
...
Excel 2002
WinXP

While I'm here asking a question ("Code in ThisWorkbook crashes Excel"),
I'll ask another real simple one (I think).

I've noticed lately that in my Project Explorer my modules, sheets,

forms,
and ThisWorkbook all show up in alphabetical order in one list under the
project. Didn't it before contain forms in a form folder, modules in a
modules folder, etc.? Did I click something to do this or is that the

way
v2002 is? Can I get it back the old way?

Thanks,
Pat








All times are GMT +1. The time now is 02:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com