Get object name for each sheet object

Tue, 31 May 2011 15:12:48 GMT

Hi Again

Now I'mplaying with adding aand removing objects

this script is totally wrong, but it gives you an insight on what I am tryiong to do - I've done it in VBa in excel, but ....

for each shobj in sheetobjects
     set box=shobj.GetProperties
     objName = box.ObjectId
     msgbox objName
next

In otherwords, I want to prove I can capture the objectID. THat way I can delete objects that I dont want

i.e. if object name <> "myobject" then delete kind of thing

Again assistance please

Re: Get object name for each sheet object

erichshiino — Thu, 02 Jun 2011 02:11:19 GMT

Hi, I created a small sample app for your case.

I made it if object.title = "name" , remove it just to don't lose all the objects in a single click...

I include message box to let you see what's going on in the code.

Hope this works for you,

Erich