NOT protect Forms

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 ?

:
 
D

Dave Peterson

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.
 
S

skrol

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top