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.

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.

Hi Bob,

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

See Debra Dalgleish at:

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


Alternatively, consider increasing the worksheet's zoom factor.


---
Regards,
Norman



"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.