Cheers!
" wrote:
-----Original Message-----
I have created a doc in excel, but I don't want users to
be able to scroll
down through the hundereds of empty cells below my two
pages. Or scroll right
across the hundreds of empty cells.
Can I restrict the size of a work shhet to prevent this
scrolling?
Rob
.
You can use code Worksheets(name of sheet).ScrollArea =
"a1:h60"
Try this code Worksheets(name of sheet).ScrollArea = ""
|