View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Restricting cell selection

1. unlock A2 thru F10
2. protect the worksheet allowing users to only select unlocked cells
--
Gary''s Student - gsnu200839


"Jemwig" wrote:

I have done this before but forgotten how .

I want to restrict the range of cells which a user can move to within a
worksheet.

i.e. only allow the cells in range a2:f10 to be selected and ignore all
others on the sheet

Can someone remind how this is done please?