Hi

A sheet has 256 columns and 65536 rows - regardless.
By Hidden, I take it your are referring to Hiding the whole sheet.

You can hide rows 1001 to 655536 to just show the first 1000 rows.
Similarly, you can select any range of columns and hide them.

Alternatively, you can set the Scroll area of the sheet to any range you
wish, and that will prevent the user from scrolling or accessing any cells
outside of that range. To set the scroll area, you would need to do that
programmatically.

Private Sub Worksheet_Activate()
ScrollArea = "A1:H20"
End Sub

Set the area to whatever you want

Copy the Code above
Right click Sheet tab View Code
Paste code into white pane that appears
Alt+F11 to return to Excel

This is event code which will be triggered automatically.


--
Regards
Roger Govier

"Fan924" wrote in message
...
Can a sheets size be reduced from 65000 rows to 1000 rows? Not just
hidden.