Seeing a part of worksheet

[rinijg]

Hi, I have created a worksheet in which many textboxes, option buttons etc are there which i drew using control tool bar (basically it looks like a dialogue box). This page acts as a control panel. On entering data in this sheet, some outputs are obtained in some other worksheet.
The height and width of this dialogue box is such that it covers all the cells from A1 to H35.
When i open this worksheet, I want to see only this dialogue box. I dont want to see other cells i.e a36- the belows cells and the columns after column H. i just want the dialogue box in the entire screen of worksheet.
Could you please tell me how to do that??

 

[Andrew Poulsom]

You can hide the rows and columns that you don't want to see. Select the rows/columns, right click and choose Hide.

 

[AlphaFrog]

• Select column I
• Ctrl+Shift+Right Arrow to select all columns to the right
• Right-click on any selected cell
• Select from the pop-up menu Hide

• Select row 36
• Ctrl+Shift+Down Arrow to select all rows below
• Right-click on any selected cell
• Select from the pop-up menu Hide

 

[JD_GFI]

If you create your form on an actual dialog box then you can show that on book open or on accessing a particular sheet.