Good day,



In Excel 2007 I am wanting to protect the formatting and formulas in a worksheet that will be used by two other people. I have tried various settings all without luck.

Imagine that you have set the formatting in column A, row 6:450, to Date. The type is 3/14/10 (dd/mm/yy). I want to retain this formatting and allow someone to input dates. The problem is that they can accidentally change the formatting or paste some other information into any cell in that column. So how does one keep the formatting set?

In my worksheet I have 34 columns which I would like to protect. All 34 columns require data entry of one sort or another. Some straight text, others numeric inputs.

Insofar as formulas, I have found a partial solution by just hiding the columns with my formulas, but is there a better way to protect them than just simply hiding?

Thanks for your help

DD