Just wanted to let everyone know that I found the answer. It is to use
conditional formatting. This will enable the user to view the selected
option (though not the drop-down arrow) in a color/format of my choice.
I hope this answer helps others who are looking for similar solutions!
--
Tbal
------------------------------------------------------------------------
Tbal's Profile:
http://www.excelforum.com/member.php...o&userid=25317
View this thread:
http://www.excelforum.com/showthread...hreadid=387971