How to 'allow minimize' using macro

[#1]

Hi All,

I have a question:

The 'allow minimize' is unticked in chart properties, how to use macro to reset it for temporary.

Which means how to use macro to tick the 'allow minimize'?

It's urgent.

Thanks a lot 🙂

[maneshkhottcpl · Accepted solution]

Hi,

U can use the below macro to check or unchecked mininize buttot. I m sending u a code for the pur[pose.

and also file is attached. Please refer it and write for any issue.

sub mze
set g = ActiveDocument.GetSheetObject("CH01")
set gp = g.GetProperties
'gp.GraphLayout.Frame.AllowMinimize = false '' use this to minimize once
gp.GraphLayout.Frame.AllowMinimize = not(gp.GraphLayout.Frame.AllowMinimize)''use this to toggle minimize
g.SetProperties gp

end sub

Thanks

Manesh Khot

[deepakk]

ops.. I was little late anyways i had made sample application u can view the same.

[#4]

It works....

Thanks you guys.....

[maneshkhottcpl]

Hi,

If its working then please checked as verify.