Dim wsh as worksheet
set wsh=...
wsh.ScrollArea= "$A$1:$F$30"
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"Jason Zischke" wrote:

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