Active object?

[#1]

HI Guys,

Any body knows the function to get the active object in a sheet?

Thanks,

[shree909]

Hi  when u use the either textbox or button and wen you goto the actions  ===>>Layout

u will find the  activate object ..

U can use that option to activate when u kick of the button..

Thanks

sree

[Gysbert_Wassenaar]

There is no function for that. You can only find that out with a macro

set s=ActiveDocument.ActiveSheet

objs=s.GetSheetObjects

for i=lbound(objs) to ubound(objs)

    if objs(i).IsActive then msgbox objs(i).getobjectid

next

[#4]

Thanks for reply.

I want to get the objet id and use it in a function , so I need to get the object id each time I click on an object....

[#5]

Can I call this macro in an expression?

Thanks,

[Gysbert_Wassenaar]

No

[#7]

Hi,

Please Find The Attachment Try this hope this is helpful for you

Regards,

Nirmal.