sheet protection

G

Guest

i am trying to protect a sheet in an excel 2000 workbook so i go to tools -
protection - sheet protection- and type in the password but then when i go to
the sheet i can make changes to the cells so in reality the sheet is not
protected
please help!
 
G

Guest

I think you need to lock the cells. Go to format cells and lock them, then
they can't be altered. (I think!)
 

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

How do you insert & delete rows in a protected worksheet? 1
hide columns on a protected sheet 2
unprotect a sheet that appears to be unprotected already 2
Userinterfaceonly 5
Change cell color in protected sheet 1
unprotect sheet (icon is greyed out) 1
protection error 2
Sorting a protected set of cells 3

Top