Sheet Protection with Dependent Dropdowns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alex - 23 Apr 2007 15:48 GMT

I have a spreadsheet that has a couple of dependent dropdowns. I would like
to turn protection on for the sheet. When I do, and I select an item from a
dropdown menu, I get a popup message saying that the field is protected and
cannot be changed. Where am I missing how to allow this? I'm using excel
2000.

Thanks,

Alex

Reply to this Message

Barb Reinhardt - 23 Apr 2007 22:22 GMT

Before you protect the sheet, set the following for the cells you want to
modify:

Format Cells -> Protection -> Locked (deselect it)

> I have a spreadsheet that has a couple of dependent dropdowns. I would like
> to turn protection on for the sheet. When I do, and I select an item from a
[quoted text clipped - 5 lines]
>
> Alex

Reply to this Message

Alex - 24 Apr 2007 15:58 GMT

The combo dropdowns span 2-3 cells, and I have unlocked those cells. The
result goes to a cell that I have also unlocked. When I turn protection on
for the sheet I still get the same error as before. Any thoughts?

Alex

> Before you protect the sheet, set the following for the cells you want to
> modify:
[quoted text clipped - 10 lines]
> >
> > Alex

Reply to this Message

Barb Reinhardt - 24 Apr 2007 16:10 GMT

Are you doing something like this

http://www.contextures.com/xlDataVal13.html

> The combo dropdowns span 2-3 cells, and I have unlocked those cells. The
> result goes to a cell that I have also unlocked. When I turn protection on
[quoted text clipped - 16 lines]
> > >
> > > Alex

Reply to this Message

Alex - 25 Apr 2007 05:54 GMT

I was trying to follow the work presented here:

http://www.xldynamic.com/source/xld.Dropdowns.html

But I'm not a VB person. The only real problem I have is the protection
issue. But I can live with it the was it is.

Alex

> Are you doing something like this
>
[quoted text clipped - 20 lines]
> > > >
> > > > Alex

Reply to this Message

Rate this thread: