Locking combo boxes

  • Thread starter Thread starter =?iso-8859-1?Q?K=E5re_Brynildsenq?=
  • Start date Start date
?

=?iso-8859-1?Q?K=E5re_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.
 
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

Unprotect Combo Box in a Protected Sheet 3
Bypass unlocked cell on protected worksheet in Excel 2003? 8
Word Lock specific drop downs on a Word Document 0
protect formulas in locked cells from changing if data is moved 3
Locked cells are still able to be selected with proper protection 1
Appearance of Data Validation Combo Box 2
combo box locked 4
Conditional Proctection? 1

Back
Top