Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 😃
Hi Maggie,
try the following code:
set mybox = ActiveDocument.GetSheetObject("LB01")
mbp = mybox.GetProperties
if mbp.Layout.Frame.ShowMode = 0 then msgbox("minimized")