Lock & Limit Scroll Area

kenshin · Jun 15th 2008

Hi.

I want users to be able to scroll top-down or sideways up to a certain point only.

What is the VBA code to accomplish this?

Let's say for example I want to limit scrolling from A to L rows 1 to 50 only.

How do I do that?

Thanks in advance!

:grin:

VBA Noob · Jun 15th 2008

Re: Lock Scroll Area

Try

Code

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

Change worksheet 1 to your sheet. You can also set the scroll area in the properties window while in VB

Also see suggestions below

VBA Noob

Dave Hawley · Jun 16th 2008

Re: Lock Scroll Area

You can also hide column & rows

Participate now!