Obtaining list of all objects on worksheet
Hello,
Is there a way to list all of the objects on any given sheet? Let's
say I have a command button and a picture on sheet 1, Excel obviously
knows those 2 objects are there, so there must be a code I could write
to find out what objects are on the sheet, or perhaps they are listed
somewhere as sheet properties. If someone can explain how to do this,
I'd appreciate it.
thanks,
Andy
|