View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Protection elements

Does this happen with every workbook of just a particular one? If it's
limited to just one workbook check that there isn't something in the workbook
event macros changing your protection. If you are prompted to enable macros
when the workbook opens click disable and see if your protection remains as
you set it.

You are saving the workbook after applying this protection aren't you?

Mike

"Eva" wrote:

Hi,
When protecting a worksheet I want users only to "Select unlocked cells" and
I check this box (and only this box) in the Data, Protection menu.

When opening the worksheet again, locked cells can be selected and the
checkbox "Select locked cells" is checked!

Why does this happen on opening the file? And how can I make it not happen?
--
Eva HDA