ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   sheet protection (https://www.excelbanter.com/excel-worksheet-functions/32857-sheet-protection.html)

aimee

sheet protection
 
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!

Anne Troy

Try the instructions here, Aimee:
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"aimee" wrote in message
...
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!




Becky

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

"aimee" wrote:

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!



All times are GMT +1. The time now is 08:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com