VBA To Deliver Object List?

[(PeteCresswell)]

Can I write a single VBA loop to enumerate all objects within an Excel .XLS?

Or do I have to know the object types/container names and enumerate the contents
of each?

 

[Guest]

see:

http://www.microsoft.com/communitie...&p=1&tid=cb2f7677-be8c-40b0-bfa9-2305acd4d167

 

[(PeteCresswell)]

Per Gary''s Student:

http://www.microsoft.com/communitie...&p=1&tid=cb2f7677-be8c-40b0-bfa9-2305acd4d167
--

Seems like the object browser seems lists all available objects whether in use
or not - as opposed to the objects that actually are in use in the .XLS.

Have I got it right?

I'm trying to figure out how the author of a certain .XLS is managing to store a
half-million rows of data. The obvious way would be to have multiple invisible
sheets - but I cannot figure out how to browse for them.

 

[bgeier]

If the worksheets are hidden you can try to look at the VBE's project
explorer to see a list of all of the worksheets used hidden or not.

If they are there, you can use the command
worksheets(-worksheetname-).visible = true (repeat for each hidden
sheet)

in a macro you could use


Code:
--------------------

sub Unhide()
for intcounter = 1 to worksheets.count
worksheets(intcounter).visible = true
next intcounter
end sub