View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default Still can select locked cells in protected sheet

Andy, I'm afraid that the way you worded it, I (for one) am not clear on
exactly what you want to accomplish. You want the user to be able to select
cells but not change them? Or not to even select the cells? And what version
are you using, please?
************
Anne Troy
www.OfficeArticles.com

"Andy" wrote in message
...
When I protect a sheet, and the only action allowed is "Select
unlocked cells", the user cannot select any locked cells, which is
what I want.

When I save the sheet, and then reopen it, the user can select locked
cells. It doesn't do him any good, since he can't alter the cell. If
he tries, he gets an error message advising him that the cell is
protected.

If I unprotect and re-protect the sheet, the behavior goes back to not
even being able to select the locked cells.

Is there a way to ensure that behavior when the locked worksheet is
re-opened?

TIA,

Andy