Leave list box unprotected while protecting worksheet

A

acukid

How do I leave a list box unprotected so that an item can be selected while
protecting the rest of the worksheet? I created the list box with the
Control Toolbox and noticed on "properties" is a lock option but making this
"false" doesn't solve my issue.
 
D

Dave Peterson

Did you give that listbox a linkedcell?

Did you lock that linkedcell?

Did you protect the worksheet that held that linkedcell?

If yes, then unlock that linkedcell.
 
Top