Locking combo boxes

  • Thread starter =?iso-8859-1?Q?K=E5re_Brynildsenq?=
  • 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.
 
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

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
Appearance of Data Validation Combo Box 2
Conditional Proctection? 1
Is it possible? 1
Enabling Autofilter and Sorting in a Protected Sheet 2

Top