Validation List and protection

[bahri]

Hi all!

While trying things out on ecxel version 2000 (I normaly use officeXP) I had
the following Problem.

When a Validation List is applied and the whole sheet is protected Excel
Version 2000 will not protect the cell and further editing using the list
feature is posible. However excel XP will protect the cell as expected.

Is there a way to protect this kind of cell in Excell 2000

Thanks all

bahri

 

[Gord Dibben]

bahri

Check out this google search thread.

Note Debra's two posts for how-to with xl2000 or mine if you want event code.

http://snipurl.com/15fcy


Gord Dibben MS Excel MVP

 

[bahri]

Thanks for the info, I see I am not alone

bahri