Kees, Try this.

Worksheets("Sheet1").ScrollArea = "A1:J20"

this will lock the worksheet at 20 rows, and 10 Columns.

enjoy, Rick


"Kees Korver"
wrote in message
...

Dear all, in one of my applications I would like to physically limit the
number of rows and columns. So, the user cannot navigate beyond - say -
20 rows and 10 columns. Any way to do this in VBA? Thanks!


--
Kees Korver
------------------------------------------------------------------------
Kees Korver's Profile:
http://www.excelforum.com/member.php...o&userid=21562
View this thread: http://www.excelforum.com/showthread...hreadid=532165