Display ALL Names of Drawing Objects
Corey,
There's the DrawingObjects collection you can loop through, printing .Name
in a suitable location.
Whilst obviously possible, do you really need 800/sheet ?
Can you not move or show/hide a few when/if needed ?
NickHK
"Corey" wrote in message
...
Is there a short code that would display ALL the names given by code to
drawing objects with in a worksheet.
I have placed approximately 800 different objects on a worksheet, they
will
eventualy used in a code to display Not Display.
But firstly i had to NAME them individually to allow for the code.
Being 800 odd i want to make sure i have not missed any, so hence the
reason
for the displaying of the objects names needed.
I would like them possibly to be displayed in a new worksheet so i can
view
them.
Can anyone assist me?
--
Regards
Corey
|