This setting will not remain after closing the file.
Place a code line in the Workbook open event to set it
each time when you open the workbook
Private Sub Workbook_Open()
Sheets("Sheet1").ScrollArea = "B1:B45"
End Sub
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl
"Phil Hageman" wrote in message ...
In the VB editor, I am typing B1:B45 in the ScrollArea
property to restrict users to that area. After saving,
closing, and reopining, the typed B1:B45 is not there, and
users can still click outside the desired area. Worksheet
is not protected.
Can someone tell me the problem?
Thanks, Phil