Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team -
Has anyone come across a function to determine which chart type we are on? Something like =ChartType('Object ID')
Best,
Sunny
Yes. Got it
Hi Sunny,
I have not tried this code before, but it looks like what you need. Hope it helps
rem ** get unique object ID for first object on sheet Main **
set s = ActiveDocument.Sheets("Main") // You can possibly have a variable to determine activesheet name
set so = s.SheetObjects(0)
id = so.GetObjectId
msgbox("ID = " & id)
Would you be able to share the sample here?