Problem with set scroll area in VBA

[Jeff up North]

Hello All,

My question is how to lock the scroll area in VBA as every time I lock the scroll area it does not save. The first sheet, (sheet1) I would like to limit scroll area to “A1:LC53” the second sheet would be (Construction Home) and I would like to limit scroll area to “A1:S43”

Here is the code I have been working with

Please Login or Register  to view this content.

I have been saving this in each sheet i.e. the sheet1 would be saved in sheet1 and construction Home would be saved in the Construction Home, is the the proper way or do they need to be in the "this work book"?


Any and All Help would be much appreciated and Thanks in Advanced , Jeff

[hafizimran]

It should be in ThisWorkBook Module.

[Jeff up North]

Hafizimran,

Thanks for the quick reply, I have tried it in "thisworkbook" but it still would not work so I figured the colde was a liitle off. Any idea on the code?

Jeff

[hafizimran]

Code is correct and it must work. Have you enabled macros? If yes then can you upload your workbook please?

[shg]

The code is fine. You need to save, close, and reopen the workbook.

[Jeff up North]

I have attached the work book as when I save it under this work book it comes back as a err. under Private Sub Workbook_Open() not sure if it has to do with the first code I have in the This work book?

Master 022213.xlsm

Thank you all for the quick replies, Jeff

[shg]

You can only have one Workbook_Open procedure. Put all the code in one or the other.

[Jeff up North]

Shg,

that solved the problem, SHG thanks for helping out, I have added to both of your reputaions and will mark this solved, Thanks again Jeff