| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to disable the scrolling in worksheet
Dear all, How can I disable the scrolling function in a Excel Worksheet. Also I want to disable the "Close Window" button. Any tips? Thanks. Best regards, David Yang -- yangyh ------------------------------------------------------------------------ yangyh's Profile: http://www.excelforum.com/member.php...o&userid=26883 View this thread: http://www.excelforum.com/showthread...hreadid=401139 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to disable the scrolling in worksheet
David,
You can hide scrollbars by Application.DisplayScrollBars = False Not sure about the Close Window button. HTH, John |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to disable the scrolling in worksheet
yangyh Wrote: Dear all, How can I disable the scrolling function in a Excel Worksheet. Also I want to disable the "Close Window" button. Any tips? Thanks. Best regards, David Yang Hi David To get rid of scrolling try Tools Options View Tab, uncheck the Horizontal and Vertical Scroll Bars in Window options Sorry can't help with Close Window button -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=401139 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to disable the scrolling in worksheet
Thank you guys. But actually I want to disable the scorlling function. Not only just hide the scrol bar. What shall I do? Thanks. David -- yangyh ------------------------------------------------------------------------ yangyh's Profile: http://www.excelforum.com/member.php...o&userid=26883 View this thread: http://www.excelforum.com/showthread...hreadid=401139 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to disable the scrolling in worksheet
If you mean you want to restrict user to selecting and/or scrolling to
within a specific area, set the ScrollArea to suit, eg B2:K20 Rt-click the sheet tab, view code and you should see the ScrollArea setting in the Properties panel, typically bottom left of the VBE. Though you might need first to select the sheetname in the top left panel and press F4. Regards, Peter T "yangyh" wrote in message ... Thank you guys. But actually I want to disable the scorlling function. Not only just hide the scrol bar. What shall I do? Thanks. David -- yangyh ------------------------------------------------------------------------ yangyh's Profile: http://www.excelforum.com/member.php...o&userid=26883 View this thread: http://www.excelforum.com/showthread...hreadid=401139 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to disable the scrolling in worksheet
Peter, It works perfectly. But I'm wondering is there any function to realiz it. Thank. Davi -- yangy ----------------------------------------------------------------------- yangyh's Profile: http://www.excelforum.com/member.php...fo&userid=2688 View this thread: http://www.excelforum.com/showthread.php?threadid=40113 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to disable the scrolling in worksheet
It works perfectly. But I'm wondering is there any function to realize
it. Thank. To set a scroll area Worksheets("Sheet1").ScrollArea = "B2:K20" and reset Worksheets("Sheet1").ScrollArea = "" Regards, Peter T |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop a worksheet from scrolling? | Excel Worksheet Functions | |||
| Stop scrolling on 1 worksheet | Excel Discussion (Misc queries) | |||
| Scrolling the Worksheet with the scrollbar | Excel Discussion (Misc queries) | |||
| Automatically scrolling to top of worksheet | Excel Worksheet Functions | |||
| Scrolling Marquee in a worksheet. | Excel Programming | |||
Linear Mode
