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

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

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

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

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

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

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