hide the rows you don't want to see.

or

use the scrollarea property of the worksheet, but it has to be see by code
each time the workbook is opened.

--
Regards,
Tom Ogilvy


"dr chuck" wrote in message
...
I would like to be able to lock a worksheet so that other users cannot
scroll
down the work sheet. How can i accomplish this.

For example i want the sheet to open to rows 1-30 and be unable to display
row 31 and higher to other users.

--
dr chuck