Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop a worksheet from scrolling? | Excel Worksheet Functions | |||
Scrolling worksheet | Excel Programming | |||
How to disable the scrolling in worksheet | Excel Programming | |||
Automatically scrolling to top of worksheet | Excel Worksheet Functions | |||
Scrolling Marquee in a worksheet. | Excel Programming |