Worksheet Scrolling
 

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

Worksheet Scrolling
 

Hi
One way would be to set the ScrollArea property to say A1:J30. However this
property is cannot be saved with the book and is lost once the book is
re-open. That is, you would have to set it in the Workbook_Open sub of the
ThisWOrkbook module.
Another way would be to hide any other row and columns outside of the
'scrollable' rectangle; unlock the cells of that rectangle (menu Format
Cells, tab Protection); and finally protect the sheet.
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"Jason Zischke" wrote:

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

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

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

Worksheet Scrolling
 

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

Worksheet Scrolling
 

Jason,
Did you look at the VBA help in Excel ?

NickHK

"Jason Zischke" wrote in message
...
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

Worksheet Scrolling
 

Thanks

It works now and exactlly how I wanted it to.

Jason

"NickHK" wrote:

Jason,
Did you look at the VBA help in Excel ?

NickHK

"Jason Zischke" wrote in message
...
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