VB to remove scroll area limit?

[Nitefox]

How do I remove a scroll area limit, other than setting it to the full row/column range of excel?

[HaHoBe]

Hi, Nitefox,

maybe like

Please Login or Register  to view this content.

Thatīs taking away any ScrollArea from the sheet (if thatīs what you want and asked for).

Ciao,
Holger

[TMS]

Set:

Please Login or Register  to view this content.

Reset:

Please Login or Register  to view this content.

Regards, TMS

[:) Sixthsense :)]

To set Scroll Area manually:

On the Ribbon, click the Developer tab, and click Properties
In the Properties window, enter a range address in the ScrollArea property box
Click on the worksheet, and you will be restricted to clicking and scrolling in the Scroll Area.

To manually clear the Scroll Area:

On the Ribbon, click the Developer tab, and click Properties
In the Properties window, delete the address in the ScrollArea property box
Click on the worksheet, and you will be able to click and scroll freely (assuming that the sheet is not protected).


Set Scroll Areas With a Macro

The Scroll Area settings are cleared when you close the workbook, and you have to set them again, each time the file opens. You can use a macro to set them, as part of the Workbook_Open procedure.

Copy this macro to a regular module in your workbook. It will set the Scroll area for each worksheet in the file, based on the Used Range on that sheet.

Please Login or Register  to view this content.

Add the macro name to the Worksheet_Open procedure in the ThisWorkbook module.

Please Login or Register  to view this content.

Source:- http://blog.contextures.com/archives...cel-worksheet/