Ensure that all the cells requiring input are unlocked first. Select
Tools|Protection|Protect Sheet. Untick the option to select locked cells,
insert a password (for what that is worth), click OK, and retype the password
when requested to, and you are ready

"stwky" wrote:

I'm looking for HELP on the EXCEL Worksheet Protect.
I'd made a table for customer to fill-in. But I need to 'LOCK' the formats,
columns and headings before sending out to my customers.
Does anyone know how I can solve this problem?
I had tried all the steps from MS Help!
Thankyou.