how to fix the size of scrollbar for a sheet

[sonikajain]

Please advise on fixing the size of scroll bar (size of sheet) for a particular sheet in a document.

[m_woolf]

I'm not sure what you mean by your subject.

I am attaching a sample application that allows the user to zoom in and out on the sheet.

[sonikajain]

Hi...

the scenario is , I have 22 tables in a sheet, displayed conditionally.

Lets say, on pressing button1 , 20 get displayed, on pressing button 2, only 2 are to be displayed. In this case, the size of my sheet is still to accomodate 20 charts, the scroll bar size remains the same , which leads to extra space.

I need to get rid of this extra space.Please advise

[m_woolf]

If a sheet has a scroll bar, it is because the objects on the sheet don't fit in the visible area. Hiding the objects has no effect on this behavior.

I can think of two approachs that might work. Both involve writing code.

One is: when the objects are hidden, minimize them. Their minimized icons can be located in the visble screen area, which should remove the scroll bar. (I just did a quick test. Minimizing doesn't work)

The other is: when the objects are hidden, move them into the visible screen area. This would require additional code to move them back to their viewing positions when they become visible.

[sonikajain]

hi...I had tried to minimise the objects but in that case too the area on the screen remains occupied and so , scroll bar does not get changed...

I am trying the secind approach now...but am facing difficulites in how would I move the objects to thier actual position again

[m_woolf]

I suggest creating variables to store the locations of each object.

vCH01Xval

vCH01Yval

[sonikajain]

thanks..!!!