How to lock horizontal scroll bar

[manojbk]

i want to lock the horizontal scroll bar in an excel sheet ..is it possible..
please hepl me

 

[Stormseed]

You can freeze the scroll area to a specific limit if that is what you are looking forward to ? In order to do that you will need a small code in VBA. Here is the line of code for locking the scrollbar on Sheet1:

Sheets("Sheet1").ScrollArea = "A1:F100"

Also you can remove the horizontal scrollbar in your Excel worksheet if that is what you want. You can accomplish this just by plonking this line of code in one of the Excel events:

ActiveWindow.DisplayHorizontalScrollBar = False

Does that help ?

 

[manojbk]

Thank u for ur quick response. my intention is to lock the sheet like a single page. it should not scroll vertical or horizontal .is it possible....

 

[Stormseed]

my intention is to lock the sheet like a single page. it should not scroll vertical or horizontal .is it possible

Yes, it is possbile. Please use the line of code which I have posted first.
I guess you know how to use it ?

 

[manojbk]

sorry , i dont know . i would be thankful to u if you can guid me..

 

[Stormseed]

What is the name of the worksheet that you want to lock the scroll area for in your Excel workbook ?

 

[manojbk]

Name of the sheet is MASTER

 

[Stormseed]

Right click on the worksheet name "Master", select the option "view code". A VB Editor would open. Now, on the right hand side of the window just a little above the white area there are 2 dropdowns, namely, "General" & "Declarations". Now, select "Worksheet" in the General dropdown and than select "Activate" in the Declarations dropdown.

Copy and paste the code below with whatever code you find there in the white area after you perform the above steps:

Private Sub Worksheet_Activate()
ScrollArea = "A1:P40"
End Sub

Note: Please change the ranges in the code to suit your preferences.

Hope this helps you

 

[Yamezz]

Old thread I know, but that was exactly what I was looking for. Thanks Stormseed.

 

[manojbk]

wowwwwwwww.. now it is working.. thank you very much...