View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default How can I enarge the font size in a drop-down list?

Formulas still work when protected.
If you are using datavalidation you cannot change the font,
you can use a macro that zooms

http://www.contextures.com/xlDataVal08.html#Font


--

Regards,

Peo Sjoblom

"BobH" wrote in message
...
1. How can I enarge the font size in a drop-down list?

2. How can I prevent someone from changing or deleting the formula in a
cell? When I try to protect the cell it prevents the formula from being
executed.