If you leave the cell unlocked (format|cells|protection tab)
then protect the worksheet (tools|protection|protect sheet)

Then you'll see that this is the usual behavior.

wrote:

Is there a way using VB to allow user input in a cell, but not allow
them to reformat that cell?

Thanks in advance!
Laura

--

Dave Peterson