Using dropdown in protected sheet

V

veggies27

I am having trouble choosing items from a drop down list when my sheet is
protected. In the same file I have certain areas where this is not a problem
at all, but everytime I try to change the cell value via dorp down, or empty
the cell, I get a "shete is protetced" type error. I thought maybe it had to
do with the fact that my drop downs are in merged cells, but I unmerged them
and had the same issue. Any thoughts?
 
A

Ashish Mathur

Hi,

It looks like that particular cell or a range comprising that cell has been
protected, Unprotect that cell to use the drop down

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
D

Dave Peterson

Is this a Data|validation cell?

If yes, then unlock that cell.

And yes, this behavior changed. (I think xl2k the cell could be locked. In
xl2002, the cell has to be unlocked. I may be wrong with the versions, but
there is a difference somewhere!)
 

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

Dependent drop down dynamic range formula, off sheet. 7
Creating drop downs for multiple cells 1
using Spell check on protected sheet 6
Do not allow Copy/Paste Functionality in a Protected Sheet 1
using strings in vlookup function calls 5
Spellcheck function in Protected Sheet 11
Protect Drop-down list from range of cells 3
Insert Copied Rows or Drag/Drop Formulas While Protected 2

Top