The purpose of the password was to prevent the users from accidentally
changing formulas inadverently.

"Mike H" wrote:

Hi,

I don't believe there is any way to prevent someone who has the sheet
password from changing it.

Just a thought, what is the point of password protection if the users all
know the password?

Mike

"Kiley" wrote:

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?