![]() |
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! |
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! |
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