software

I trying to create a work sheet that only allows a user to choose an
option from a drop down menu once, after that I would like it to be
locked, does any one know if this is possible.

Thanx
Alex--
alexandra60
------------------------------------------------------------------------
alexandra60's Profile: www.excelforum.com/member.php...oamp;userid=31215
View this thread: www.excelforum.com/showthread...hreadid=508881Depends on how you made the dropdown box and what version of excel you're using.

Did you use Data|Validation, a dropdown from the Forms toolbar or a combobox
from the control toolbox toolbar?

If you used xl97 and data|validation, where was the list--typed into the
data|validation dialog or on another sheet.
alexandra60 wrote:
gt;
gt; I trying to create a work sheet that only allows a user to choose an
gt; option from a drop down menu once, after that I would like it to be
gt; locked, does any one know if this is possible.
gt;
gt; Thanx
gt; Alex
gt;
gt; --
gt; alexandra60
gt; ------------------------------------------------------------------------
gt; alexandra60's Profile: www.excelforum.com/member.php...oamp;userid=31215
gt; View this thread: www.excelforum.com/showthread...hreadid=508881

--

Dave Peterson


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: www.excelforum.com/member.php...oamp;userid=31215
View this thread: www.excelforum.com/showthread...hreadid=508881
--
alexandra60
------------------------------------------------------------------------
alexandra60's Profile: www.excelforum.com/member.php...oamp;userid=31215
View this thread: www.excelforum.com/showthread...hreadid=508881