Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Password can be changed in 2000
Hi,
I am sure this has been covered already but I can't seem to find it. I have put together a workbook in Excel 2000 that will be sent out to co-workers, users and viewers. I want the users to be able to make changes to the cells but not the viewers, they just need to be able to see the final product. I have protected each worksheet using a password (Tools|Protection|Protect Sheet| put in a password.) My question is this. When a user, who knows the password, goes to re-lock the sheet after making changes types in the password incorrectly/changes the password it is changes for that sheet. For example if they original password was 1234 and they re-protect the sheet and type in 2345 Excel 2000 picks up the new password. The other users won't know of this change and the person who made the change might not realized they did it. Is there any way to make sure this doesn't happen? Can I set the password so it can't be changed? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Password can be changed in 2000
Figured it out! Thanks.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Can the default size of an excel 2000 worksheet be changed? | Excel Discussion (Misc queries) | |||
How do I create a List in Excel 2000 | Excel Worksheet Functions | |||
Validate MsgBox Entry to Data in Cells | Excel Discussion (Misc queries) | |||
Rogue Password on Properties and References | Excel Discussion (Misc queries) |