Combobox locked
 

I have a combo box from the control toolbar on a cell but when I lock
the worksheet, it will not work. Is there a way to override this or
should I change my combo box? The worksheet must be locked.

Combobox locked
 

Do you have a linkedcell associated with that combobox?

If yes, is that linkedcell on that same protected worksheet? And if yes, is
that cell locked?

If all these are true, how about just unlocking that cell?

Maggie wrote:

I have a combo box from the control toolbar on a cell but when I lock
the worksheet, it will not work. Is there a way to override this or
should I change my combo box? The worksheet must be locked.

--

Dave Peterson