For example

Sub Scroll_Lock()
Worksheets("Name sheet").ScrollArea = "A1:J29"
End sub

With Tools-Option-scollbars You can enable them again en hidden rows can be
unhide

"sameerce " schreef in bericht
...
Hi,

I wanted to lock the view of Excel sheet so that only certain number of
rows and columns are displayed to the user. Since I have an Excel sheet
where in only 50 rows are to be displayed and data has to be entered in
these cells. There is no need for showing the rest of the cells. The
user should not be able to scroll horizontally or vertically beyond
this number of cells.

Can this be acheived by some means.


Thanks,
Sameer


---
Message posted from http://www.ExcelForum.com/