How to know objects' show mode throuth macro

[#1]

Dear All,

Is any way i can know the chart's show mode through macro.

for example:

There is a chart 'CH111', it will show or hiden depends on some selection. The show conditional is UserType = 'Teacher' in layout property sheet. I wanna know currently the chart is shown or hiden through macro, so that i can change some setting of this chart. How to write the script?

Thanks a lot 😃

[#2]

Hi Maggie,

try the following code:

set mybox = ActiveDocument.GetSheetObject("LB01")

mbp = mybox.GetProperties

if mbp.Layout.Frame.ShowMode = 0 then msgbox("minimized")

Unfortunately I didn't find and overview what 1, 2 etc. may mean, but I am sure you'll will figure it out.

cheers

Florian