Protecting cells and worksheet

[Lovelock, David]

I have a workbook comprised of two worksheets. Worksheet 2 is completel
protected. No problem. However, worksheet 1 should have all of the dro
down list boxes available to pick new selections, but I don't want th
user's to be able to modify anything else on the sheet. I tried t
unlock the drop down boxes then lock the entire sheet but that didn'
work. Any hints

 

[Dave Peterson]

Did you unlock the linked cell (or even move it to another worksheet)?

If that didn't help, what do you mean by dropdown list boxes?

Data|Validation
Dropdowns from the forms toolbar
comboboxes from the control toolbox toolbar
listboxes from the forms toolbar
listboxes from the control toolbox toolbar

 

[Lovelock, David]

Dave - The drop down boxes where from the Forms Menu. When I go int
Format Control for th edrop down bax I went to the protection tab an
unchecked the Locked option. I then loacked the worksheet. I am usin
the drown down boxes to let the user select options which build u
pricing. I don't want them to be able to change any of the formula
involved though.

Thanks,

Dav

 

[Dave Peterson]

But is the cell linked to the dropdown unlocked?

If that cell is locked and the sheet is protected, then the user can't change
it--even via the dropdown.

If it's important, you could put that linked cell on a separate (and hidden)
worksheet.

And even though you didn't ask, you may find Data|validation easier to
implement.

Debra Dalgleish has some nice notes at:
http://www.contextures.com/xlDataVal01.html