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

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" <BobH@discussions.microsoft.com> wrote in message
news:A63E65DE-CFB3-40FA-B1D8-0E576A436885@microsoft.com...
> 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 data>validation you cannot change the font,
you can use a macro that zooms

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


--

Regards,

Peo Sjoblom

"BobH" <BobH@discussions.microsoft.com> wrote in message
news:A63E65DE-CFB3-40FA-B1D8-0E576A436885@microsoft.com...
> 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.