Locking combo boxes

K

Kåre Brynildsenq

Hi,

i have a worksheet with several combo boxes an drop down
lists. I have succesfully managed to lock and unlock
the "normal" cells that i want, but it is impossible for
me to unlock the combo boxes and drop down lists. Does
anyone know how i can do that? I have tried to
set "Locked" to "False" under Properties, but it doesn't
help. (Sorry for my english, i'm norwegian)

Kåre.
 
D

Dave Peterson

Is the linked cell locked? If yes, try unlocking that. (Maybe hide the
row/column it's in to keep it safe.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo box 0
Link a text box based on drop down box with four options MS Word 365 0
Drop down list control value in vba 2
Unprotect Combo Box in a Protected Sheet 3
how can I lock/unlock a range of cells depending on state of a checkbox? 4
Password protecting multiple pages, and then some. 7
Bypass unlocked cell on protected worksheet in Excel 2003? 8
Locking by multiple users possible? 0

Top