Specify ScrollArea in a Sheet

[helmekki]

Hi there

IS there a code to set the scrollArea as the follow:

Code:
--------------------
Sheet1.ScrollArea = "A1, A4, A7"
--------------------


i mean to scroll, only, in the mentioned cells A1 A4 A7.


Thank u

 

[Ron de Bruin]

Hi

Not with ScrollArea, the range must be one area

But :
Uncheck locked first in the properties of the three cells

If you are using 2002 or 2003 you can protect your sheet and uncheck
Select locked cells.

If you use 97 or 2000 you must use code to do this.
post back if you want a example

 

[dominicb]

Good evening Helmekki

You might have to clarify what you mean here, Hesham. You can
certainly restrict a user to a RANGE, but if you want to restrict
individual cells, you might be better off using the Tools > Protection
method. Use this to restrict a user to an area:

Worksheets("Sheet1").ScrollArea="A1:B100"

and this to undo it:

Worksheets("Sheet1").ScrollArea=""

is this what you meant?

HTH

DominicB