Hide Navigationbar / Maximize Table

[#1]

Hi everybody,

I have another Layout Question.

I built a Navigationbar. This bar is on the left site on the screen. The User should have the option to Hide this bar. I had created a Button and set a Variable to HiDe/Show the Navigationbar. My Question is now: Is it possible to maximize the content which is on the right side of the sceen? The Object maximize function where i can set the object ID is not so great beacause this is to big.

[giakoum · Accepted solution]

I strongly advise against, but you can use this sub to set width, height and position of chart :

sub ChangeChartSizePosition

set vObj = ActiveDocument.GetSheetObject("CH01")

set vFrame = vObj.GetFrameDef

set vSize = vFrame.Rect

vSize.Width = 200

vSize.Height = 200

vObj.SetFrame vFrame,true,dummy

vPos = vObj.GetRect

vPos.Top = vPos.Top + 200

vPos.Left = vPos.Left + 200

vObj.SetRect vPos

set vObj = nothing

set vFrame = nothing

set vSize = nothing

set vPos = nothing

end sub

Remember to uncheck "Size to Data" option in the Layout tab of the chart's properties and check the "Allow Move/Size" option.

[giakoum]

Hi Patrick.

please close the discussion if this worked.

Thank you.