Ive develop an Excel worksheet for data collection. The worksheet contains
info in cells A1 to M192. I want users only to utilize these cells and not
have the ability to scroll to blank worksheet area. Is there a way to
prevent user from strolling pass a particular column and row?

Thanks

Hi Paul

Place the sub below in the ThisWorkbook module.

Private Sub Workbook_Open()
Sheets("Sheet1").scrollarea = "A1:M192"
End Sub

--
XL2002
Regards

William



"Paul" wrote in message
...
| I've develop an Excel worksheet for data collection. The worksheet
contains
| info in cells A1 to M192. I want users only to utilize these cells and
not
| have the ability to scroll to blank worksheet area. Is there a way to
| prevent user from strolling pass a particular column and row?
|
| Thanks

sheets("Sheet1").scrollarea = "$A$1:$M$192"

HTH

"Paul" wrote:

Ive develop an Excel worksheet for data collection. The worksheet contains
info in cells A1 to M192. I want users only to utilize these cells and not
have the ability to scroll to blank worksheet area. Is there a way to
prevent user from strolling pass a particular column and row?

Thanks

If you know that your users will not need any additional rows or columns, the
Worksheet.ScrollArea would do you fine.

But what if you require later to expand the area available to your users?

I for one have not found the solution, yet, to dynamically restrict the
ScrollArea to the user.

"Paul" wrote:

Ive develop an Excel worksheet for data collection. The worksheet contains
info in cells A1 to M192. I want users only to utilize these cells and not
have the ability to scroll to blank worksheet area. Is there a way to
prevent user from strolling pass a particular column and row?

Thanks