Page Scroll

[bengaluru]

Hi,

I have a spreadsheet with about 300 rows and columns up to AB. Is it possible to stop the page to scroll beyond the 300 rows and AB columns.

Thanks

[Andy Pope]

Either hide the rows and columns that are beyond your required area.

Or set the ScrollArea property. On the Control Toolbox toolbar click the Properties icon. With the sheet selected specify the range in the ScrollArea property.
Note this property will not be retained when the workbook is closed.

[dominicb]

Good afternoon bengaluru

I have a spreadsheet with about 300 rows and columns up to AB. Is it possible to stop the page to scroll beyond the 300 rows and AB columns.

To restate the ScrollArea property everytime the workbook is opened, use something like this :

Private Sub Workbook_Open()
Worksheets(1).ScrollArea = "A1:AB300"
End Sub

This needs to go in your ThisWorkbook module.

HTH

DominicB

[bengaluru]

Thanks Andy Pope and dominicb. But unfortuantely the code does not work.

Take care

[Andy Pope]

Are you sure you placed the code in the Thisworkbook object?

You will of couse need to run the routine before it takes affect. Either press F5 or simply save and re-open the workbook.

And of course you will need to have macros enabled.

[bengaluru]

Thank you so much Stormseed for your prompt reply. Much appreciated. You have a great weekend.

[nikesh]

Dear Bengaluru,

Just do the following and and your query is solved:

Select range A1:AB300

Click Menu Format>Cells
Now Click "Protection" Tab and uncheck "Locked"

Click Menu Tools>Protection>Protect Sheet

New small window will open.

Now uncheck "Select locked Cell" and enter the password in first box

Click OK.

[Andy Pope]

Simply pasting the code into the correct place will not affect the scroll area.

You have to actually run the code. I suggested a way to execute the code as it would not be available via the Macros dialog.

Granted once the workbook is saved and re-opened this will happen automatically.

[bengaluru]

Thanks Andy Pope and stormseed. Your help is much appreciated.

Yes it now worked when I used the Object browser and located the ThisWorkBook_Open.

How can I use the same if I have more than one sheet, because everytime the same ThisWorkBook_Open opens and gives me an error message if I use a different range.