Find Object

[cbaqir]

What's the easiest way to find an object if you know the Object ID? Also, isn't there a keyboard shortcut to restore hidden or minimized objects?

[sunny_talwar · Accepted solution]

May be go to Sheets tab on document properties;

[sunny_talwar]

For unhidding hidden object you can try: Ctrl + Shift + S

[cbaqir]

I tried that but don't see the object referenced in the Governance Dashboard. I noticed containers show up but the charts within them don't.

[Gysbert_Wassenaar]

I find it easiest to use the Document Analyzer to find objects in document with lots of objects. You could also export the layout and find it in the exported text files.

[Frank_Hartmann]

You can use a macro

''****************************************************************************************

''***********************        SearchObjectID      ***************************

''****************************************************************************************

Sub SearchObjectID

'Call setVariable

iObject=inputbox("Tragen Sie bitte die gewünschten Objekt-ID ein!")

          for i = 0 to ActiveDocument.NoOfSheets - 1        

          set ss= ActiveDocument.GetSheet(i)             

          shNa = ss.GetProperties.Name                       

          ActiveDocument.ActivateSheet(shNa)                 

          ActiveDocument.GetApplication.WaitForIdle()    

          Objecte = ActiveDocument.ActiveSheet.GetSheetObjects                       

              For j = lBound(Objecte) to ubound(Objecte)

                    if Objecte(j).GetObjectType = 12 or Objecte(j).GetObjectType = 15 or Objecte(j).GetObjectType = 16 or Objecte(j).GetObjectType = 11 or Objecte(j).GetObjectType = 6 or Objecte(j).GetObjectType = 22 then

                      NameObject = Objecte(j).GetObjectID   

                          if instr(NameObject,iObject)=0  Then

                          z=z+1

                             else                 

                              if instr(NameObject,iObject)>0  Then

                              set s=ActiveDocument.Sheets(i)       

                              s.SheetObjects(iObject).Activate

                              msgbox("Die Objekt-ID"&" "&iObject&" "&"wurde gefunden. Falls sie das markierte Objekt nicht sehen können, wechseln sie bitte in den Entwufsmodus und starten sie das Makro erneut!")

                              Exit sub

                              else                                                                                      

                                end if

                            end if

                      end if

                 next

           next 

msgbox("Die Objekt-ID"&" "&"<"&iObject&"> "&"wurde NICHT gefunden. Bitte überprüfen sie ihre Eingabe auf Rechtschreibfehler")              

End sub

hope it helps!

[m_woolf]

Shift + Ctrl + S is the shortcut for showing hidden objects.

I don't know of a command for restoring minimized objects.

You can get to the Properties of an object when you know the ID, by going to Sheet|Properties|Objects.

I don't know of a way to figure out where the object is or activate it (without using macros).

[HirisH_V7]

Hi,

Still you cant find means,

where if your document has data reduction, the option 'Document Objects' will appear only if you are a ADMIN if you are a USER at the Section Access this option won't be available for you.

-Hirish