How to lock the scroll area in excel 2010 [SOLVED]

[pkd37223]

I need your help on "how to lock the scroll area" in the excel workbook. I have tried the below but it is not working when I close and re-open the workbook (I have saved the work book before closing).


Alt+F11----->View---->properties window--->scroll area---> I have provided the cell range where I need to apply the scroll lock. When I do this it is working fine. However, when I close and re-open the excel file the "scroll area lock" is not working.


Can you please provide a solution for this.


Thanks in advance for your help on this.


Regards, Phani

 

[oldchippy]

Hi pkd37223,


Does this help?


http://office.microsoft.com/en-gb/excel-help/freeze-or-lock-rows-and-columns-HP010342542.aspx

 

[bobhc]

Good day pkd37223


Try this


right click tab

view code

hit f4

in the scroll area put A1:AA32 or however many columns you want across

enter

hit alt+q to close the window.

save the workbook

 

[pkd37223]

Hi oldchippy,


Thanks for your quick reply. Unfortunately, it doesn't provide the information I am looking for. I need to lock the scroll area in the specified range of cells. For e.g. if I apply the scroll lock for A1:U32 range, I do not want to scroll the remaining area except A1:U32 range.


Once again thanks for your help.


Regards, Phani

 

[sgmpatnaik]

@pkd


Hi


please follow the bobhc instruction it will give you the exact what do you want


steps for lock the sheet scrolling


1. Right click on you desire sheet


2. Select View code


3. press F4 (Properties)


4. select ScrollArea


5. Give your desire Range (A1:U32)


Now your scrolling is locked


Hope it is solved your problem


Thanks


SP

 

[pkd37223]

Hi bobhc,


Thank you very much for your reply.

The suggested way of locking the scroll area is working fine. However, when I save, close and re-open the file I didn't the see the "scroll area lock" what I have applied earlier (before closing the file).


Can you please suggest any solution for this?


Regards, Phani

 

[sgmpatnaik]

@pkd


Hi


if the solution is not work then try the below code

[pre]

Private Sub Workbook_Open()
ActiveWorkbook.Worksheets("Sheet1").ScrollArea = "Summary_Scroll_Lock_Area"
End Sub

[/pre]

Summary_Scroll_Lock_Area is your Desire Range (A1:U32)


Hope it will solve your problem other wise please inform


Thanks


SP

 

[pkd37223]

Great sgmpatnaik. Now it is working fine now.


Thanks a lot for your help on this.


Regards, Phani

 

[sgmpatnaik]

@Phani


Hi


Glad you solved the problem


Thanks


SP