protection of your worksheet

G

Guest

i need to protect my worksheet from edit.... I have two worksheets. one has
the protection but the other won't protect.. Im highlighting the area and
then selecting protect and password.. but it is not working.. any suggestions
 
G

Guest

hi

after selecting the area, choose format / cells - choose the protection tab
and ensure LOCKED is ticked - then choose tools / protection / protect sheet

....note, worksheet/workbook protection in excel is easily broken

Cheers
JulieD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy protection from one worksheet to another 2
Protect and Edit Object 1
allow a user to edit ranges in a protected worksheet 3
To protect all worksheet simultaneously in a excel workbook 1
protection error 2
Userinterfaceonly 5
Using solver function in a locked (protected) worksheet 2
Excel Disallow movement of embedded PDF 2

Top