protection of your worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

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

Excel Protection 2
Copy protection from one worksheet to another 2
Protect and Edit Object 1
allow a user to edit ranges in a protected worksheet 3
Using solver function in a locked (protected) worksheet 2
Excel Move or Copy Stopped Working? 0
Worksheet protection 1
Userinterfaceonly 5

Back
Top