View Single Post
  #2   Report Post  
 
Posts: n/a
Default


-----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 = ""