Specify ScrollArea in a Sheet
 

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


--
helmekki


------------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...fo&userid=6939
View this thread: http://www.excelforum.com/showthread...hreadid=379684

Specify ScrollArea in a Sheet
 

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"helmekki" wrote in message
...

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


--
helmekki


------------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...fo&userid=6939
View this thread: http://www.excelforum.com/showthread...hreadid=379684

Specify ScrollArea in a Sheet
 

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


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=379684