Worksheet Protection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi

select the cells you want people to be able to get to ... (click in the
first cell, hold down control, click in the second etc)
choose format / cells go the protection tab
untick locked

now choose tools / protection / protect sheet .. put a password in if you
want to slow them down slightly from unprotecting the sheet and click OK

note, this protects the contents of the sheet, it does not stop people
deleting the sheet - for that you need workbook protection too.
 
Back
Top