Leave list box unprotected while protecting worksheet
 

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.

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.

acukid wrote:

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.

--

Dave Peterson