View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Worksheet Scrolling

Jason,
Whilst you cannot prevent scrolling, you can set the .ScrollArea of a
worksheet, so the user cannot wander outside.
It only functions if the sheet is protected and AFAIK is not persistent; you
have to set it each time the workbook is opened.

The user may be able to scroll depending on the values of their screen
resolution and Excel zoom.

NickHK

"Jason Zischke" wrote in message
...
Hi All,

Is There a way to disable the srcolling on a worksheet os that a user

can't
scroll on a worsheet?

Thanks in Advance

Jason