Restrict cells selected to specific range name
in [Programming]
|
Prev: Strange thing when copying a range !!
Next: How do i select the coordinates of the first column & last row in a pasted range
From: John on 15 Dec 2009 08:25 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
From: john on 15 Dec 2009 09:06
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 |