Limit scroll area to a union

**Einstahb** · 10-31-2011, 07:57 PM

Hi,

I know how to limit the scrolling area for one range...

Worksheets(1).ScrollArea = "A1:L50"

Is it possible to limit the scrolling area to multiple ranges such as a union?

Something like this, that works...

Worksheets(1).ScrollArea = "A1:B50; D10:E40"

Thanks

**mikerickson** · 10-31-2011, 08:18 PM

How would that act?

**Richard Buttrey** · 10-31-2011, 08:21 PM

Hi,

As far as I'm aware you can only limit the scroll area to a contiguous range.

One work around might be to Unlock all the A1:B50 & D10:E40 cells and lock all the rest in the A1:E40 range. Then switch on sheet protection and untick the 'select locked cells.

Now specify the .ScrollArea as "A1:E40" in your code.

Regards

**davesexcel** · 10-31-2011, 08:44 PM

Most Scroll areas are for one particular area.
If you have more than one area you want to allow editing, it maybe best to just unlock those cells and the protect the sheet, then only the unlocked cells can be edited.

or what Richard said....