View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
YESHWANT JOSHI[_2_] YESHWANT JOSHI[_2_] is offline
external usenet poster
 
Posts: 42
Default Making Drop Down Box Visible with Excel 2003

if u are creating drop down boxes thru data validation and protecting the
sheet, drop down box will not be available after protecting the sheet.

Option for the same is before entering the password for protection, juse
below where u are entering password, there are so many options under "allow
all users of this worksheet to ", kindly select the "use Autofiler" under the
same and then give the password. now drop down box will be available.

kindly click yes below, if it helps

"it''''''''sh hardy" wrote:

I have 2 drop down boxes on my spread sheet... People don't see the drop down
box so they just type answers next the cell... How can I make the drop down
arrow visible, and please note I am using Excel 2003