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