lock a font in an order form

S

shannon007

I want customers to be able to type their information directly into unlocked
cells, but not have the ability to change the font or size. Is this possible?
 
G

Gord Dibben

Select the cells to be typed into.

Format>Cells>Protection>uncheck "locked"

Tools>Protection>Protect Sheet.

You can type into the cells, but will not be able to change fone color or size.


Gord Dibben MS Excel MVP
 
Top