Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Hi Patrick.
please close the discussion if this worked.
Thank you.