I'm using excel 2000, and I created the Combo Box using the Forms tool
bar.

The combo box is working but I would like other users to be able to
choose one option but not be able to change it if someone has already
chosen an option.

Its for a diary on our network, so that people can request a day off.
With the way things are at the moment I can't trust anyone lol.


--
alexandra60
------------------------------------------------------------------------
alexandra60's Profile: http://www.excelforum.com/member.php...o&userid=31215
View this thread: http://www.excelforum.com/showthread...hreadid=508881