Using listboxes in a protected sheet

  • Thread starter Thread starter Jeanie Martin
  • Start date Start date
J

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?
 
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.)
 
Back
Top