combo box froze in cell

  • Thread starter Thread starter flg@access4less
  • Start date Start date
F

flg@access4less

I have a combo box in vbs on a excel work sheet.When i protect the wor
sheet my combo box will not work it shows my items but will not functio
with the formuals it is froze in the cell..When not protected it work
great
 
flg,

If the combo box is linked to a cell, the cell must be unlocked (Format -
Cells - Protection) so the combo box can change it.
 
You must log in or register to reply here.

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

Add a combo box 1
Unprotect Combo Box in a Protected Sheet 3
Combo box value does not update in Excel 2007 4
Combo Box dropdown data 20
Bypass unlocked cell on protected worksheet in Excel 2003? 8
Combo Box 2
how do set excel up to auto replace a file? 1
combo boxes 1

Back
Top