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

[BobH]

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.

 

[Peo Sjoblom]

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

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

 

[Norman Jones]

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.