How to disable the scrolling in worksheet

[yangyh]

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

[Paul Sheppard]

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

[[email protected]]

David,

You can hide scrollbars by

Application.DisplayScrollBars = False

Not sure about the Close Window button.

HTH,
John

[yangyh]

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

[Peter T]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[yangyh]

Peter,

It works perfectly. But I'm wondering is there any function to realize it. Thank.

David

[Peter T]

> 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