View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jason Zischke Jason Zischke is offline
external usenet poster
 
Posts: 147
Default Worksheet Scrolling

Hi

What is the code for the scroll area property

Jason

"NickHK" wrote:

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