Pagebreak

[That's Confidential]

How do you put a page break type thing in an Excel spreadsheet so that a
user cannot scroll down the page anymore?

Thanks

 

[Frank Kabel]

Hi
not sure what you're trying to achieve but maybe the
function 'Windows - Freeze Panes' is what you're looking
for.

 

[DDM]

Confidential, the closest thing to what you're looking for, as I see it,
would be to hide all the rows below a certain point. Select all the rows you
wish to hide, then Format > Row > Hide. That creates the illusion that the
worksheet ends at that point.

 

[That's Confidential]

What I am trying to achieve is so that, I have a spreadsheet set up, however
I don't want people to be able to scroll down the page past row 37 or column
N as there is no need for them to!

Thanks

 

[DDM]

Righto, Confidential. In that case you'll probably want to hide everything
below Row 37 and everything to the right of Column N.

Alternatively, you can hide any formulas you don't want people to see and
lock cells you don't want people to change, then protect the worksheet. See
Format > Cells > Protection and Tools > Protection > Protect Sheet.

Of course, you can both hide columns and rows and protect the worksheet.

 

[Gord Dibben]

That's

You can hide the rows and columns you don't want used and protect the sheet
after un-locking A1:N37.

If using Excel 2002 or 2003 you have many options for selecting on a protected
sheet.

See options under Tools>Protection>Protect Sheet.

You may want to try setting the Scroll Area using VBA.

This setting will not remain after closing the file.
Place a code line in the Workbook open event to set it
each time when you open the workbook.

Private Sub Workbook_Open()
Sheets("Sheet1").ScrollArea = "A1:N37"
End Sub

Adjust to your sheetname and range.

Gord Dibben Excel MVP