NOT protect Forms

  • Thread starter Thread starter skrol
  • Start date Start date
S

skrol

Good Morning

In a sheet I have a checkbox and a combo-box.
I want to protect every cell in that sheet, make it "Read-Only", th
only things I don't want to be protected are the two forms. So tha
they keep on working, and I can continue selecting an item from th
combo-box.
Till now I can't manage that.
By protecting the sheet, the two foms always are protected.
I can't select them to be "no-protected".

Please, Some knows the trick ?

:
 
Did you assign a linked cell to the checkbox and combobox?

Did you lock those cells?

Maybe putting them on a different sheet (and hide that sheet) or unlocking those
cells (and hiding the column??) would work.
 
Thanks Dave,
I already found it out.
Indeed I had locked the cell where the form writes to.
Unlocking resolved my problem as you said.

Skrol
 
Back
Top