Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to change the color of the minimized Icon, but when it is maximized it should change to the original color. Thank's in advance
Regard's
Amar[:D]
write a macro in such a way that before minise u apply one color and after maximise apply another color 🙂
Does any one have a generic macro, which can change the color of a chart when minimized & will restore the original color when maximized.
Thanks & Regards
Amar
Hi,
I understand that you want to change the color of the caption? The script below will do that. You only need to decide when to call this macro;)
sub ChangeColor
set obj = ActiveDocument.GetSheetObject("CH01")
p = obj.GetProperties
if obj.IsMinimized then
p.GraphLayout.Frame.ActiveBgColor.PrimaryCol.Col = RGB(255,100,0)
p.GraphLayout.Frame.BgColor.PrimaryCol.Col = RGB(2,100,0)
else
p.GraphLayout.Frame.ActiveBgColor.PrimaryCol.Col = RGB(255,100,0)
p.GraphLayout.Frame.BgColor.PrimaryCol.Col = RGB(2,100,0)
end if
obj.SetProperties p
end sub
Cheers
Karol
Thank's a lot Karol.
Regards
Amar