attach / detach

[ali_hijazi]

Hello

How can I check using a macro if the sheet object is attached or detached?

[Gysbert_Wassenaar]

sub IsDetached

set chart = ActiveDocument.GetSheetObject( "CH01" )

set p = chart.GetProperties

msgbox p.Detached

end sub

[jagan]

Hi,

I checked there is no property to check whether an object is Attach or Detach.  You can attach or detach an object.

Check attach file.

Regards,

Jagan.

[jagan]

Great Gysbert.

[whiteline]

Hi.

I checked...

Look carefully what Gysbert suggested.

There is GetProperties method.