Detach a table/Graph using condition

[santhoo_san]

Hi,

Can any one suggest, how to detach a table / graph based on condition.

I want to detach a single table on a tab on selection that table, it should detach only if I select that table otherwise it should be attached to the data. I dont wish to use the 'Detach' or 'Detached' option every time. Is there a way to do this by using some conditions?

Thanks

Santhosh

[bluishjoe]

You could do it with a macro, using this instruction to detach

ActiveDocument.GetSheetObject("YOUR_OBJECT_CODE").Detach

and this to attach again

ActiveDocument.GetSheetObject("YOUR_OBJECT_CODE").Attach