View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrew[_56_] Andrew[_56_] is offline
external usenet poster
 
Posts: 130
Default 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