Thread: Restrict cells selected to specific range name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
  
Posts: 2,069
Default 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
Reply With QuoteReply With Quote