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

Protecting sheets with drop down boxes 0
Creating drop downs for multiple cells 1
Protect Drop-down list from range of cells 3
Protected sheet - attempt to delete row = unmerged cells 5
Protect sheet but be able to merge cells 1
Data Validation - Drop Down 3
using Spell check on protected sheet 7
Protecting/Unprotecting all sheets with macro leads to "image" iss 3

Top