Using listboxes in a protected sheet

[Jeanie Martin]

I have a series of listboxes (20) on a spreadsheet which
work correctly until I protect my spreadsheet then they
refuse to work.

I have unlocked other data fields on the same sheet and
they remain functional but these listboxes refuse to
work.

I used Goto Objects to select them altogether and then
unchecked the Objects box when protecting the worksheet.
But to no avail.

Is it affected by the 12 or so hidden rows which contain
the data reflected in the list boxes? I don't believe
this is the answer really. Any advice?

 

[Dave Peterson]

Do you have a linked cell on that worksheet? Is that linked cell locked?

(If yes, either unlock that cell or move it to another sheet.)