Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet protection and "Group and Outline" | Excel Discussion (Misc queries) | |||
Password protection of Excel Sheet linked to Bloomberg Data | Excel Discussion (Misc queries) | |||
Sheet Protection Unlock | Excel Worksheet Functions | |||
Cell Colors and Sheet Protection | Excel Discussion (Misc queries) | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |