View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken
 
Posts: n/a
Default Protection and warning popup

I understand how to protect the whole sheet and allow certain cells to be
populated. two part question.

1) is there a way to allow the cursor to only spot or start with the
unlocked cells? Almost like a fillable PDF? I had an excel sheet where it
ignored the protected areas and only went to the unprotected user cells.

2) If the above cannot be done, how do you turn off that "this sheet is
protected" popup? My users will find out they can't change the sheet, but
don't want them to get as annoyed as I do when I accidently click the wrong
cell.

Thanks.
--
Continuously think of new ideas and do what it takes to create it.