"Kiley" wrote in message
...
I have password protected an Excel Workbook. However, users of this
Workbook
need to unprotect the Workbook to make changes and then re-protect the
Workbook. Is there a way to lockdown the password so that when
re-protecting
the Workbook, the password cannot be changed to something else?

Password protection in fact offers very little protection. It is very easy
to crack a password in seconds. With that in mind you may like to evaluate
the cost benefit of very limited protection against the hassle of having
password protection.

One way of giving some protection to formula is to colour code those cells.
This would, at least, warn users not to tamper with the contents. You would
also need to change to printing all black (an option available on many
printers) if using a colour printer.

For a much better level of protection you would need to go to encryption.
However, again you would need to evaluate the cost benefit of this option.

Bill R