PDA

View Full Version : Module class and form Listed in VBA without folders



mohanvijay
04-24-2011, 07:51 PM
Hai ,
I am using Excel 2003
when i go to the VBA and insert modules or forms they are listed like below order
1.Module1--- this module which i insert
2.class1---- this class Which i insert
3.Sheet1(Sheet1) ---Default
4.Sheet2(Sheet2)---Default
5.Thisworkbook---Default
6.Userform1---This Form Which i insert

but till yesterday they were listed like below

1.Sheet1(Sheet1) ---Default
2.Sheet2(Sheet2)---Default
3Thisworkbook---Default
(folder named Forms)
4.Userform1
(folder named Modules)
5.Module1
(folder named Class Modules)
6.Class1

Why they are listed differently and how i correct that
please help

mikerickson
04-24-2011, 08:18 PM
In Excel 2004 & 2011, at the top of the Project Explorer, there are icons, one of which has a tool tip "Toggle Folders". When I toggle folders, my list changes as you describe and back.