Restrict cells selected to specific range name
 

HI,

I would like to restrict selection of cells to only a range say the
dimensions of a range name. Is this possibly in VBA please.

EG My rangename is Weeks which is the range A1:B10 and i dont want any users
to access cells outside of this range. Hope that makes sense.

Thanks
JB

Restrict cells selected to specific range name
 

try using Scrollarea property

to set scrollarea

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

to clear

Worksheets(1).ScrollArea = " "
--
jb


"John" wrote:

HI,

I would like to restrict selection of cells to only a range say the
dimensions of a range name. Is this possibly in VBA please.

EG My rangename is Weeks which is the range A1:B10 and i dont want any users
to access cells outside of this range. Hope that makes sense.

Thanks
JB