Personally, in that situation, I think I would keep multiple secure backups
of my own, to restore things as needed. In addition, I would investigate
installing a "Before Save" macro that would, if necessary, copy all the data
to a secure filename and save it with the proper password. This file can
then be copied and re-named and placed for use.

BTW, if everyone who uses the file knows the password, and must un-protect
the file before using it..........what's the point of the password? Why not
just put the file in a secure directory that only your approved users have
access to?

hth
Vaya con Dios,
Chuck, CABGx3





"roel1973" wrote:

Lets say I have a file that is on a shared drive that multiple users use. The
file is not saved as a shared workbook. The file is password protected and
all users know password. Is there a way to restrict the users from changing
the password when they are re-protecting the workbook after they have made
changes?

I also have found that if I protect a work book some one who has the
password can then protect and share the work book putting a new password over
mine thus now not allowing me to edit the workbook. Is there any way to
restrict users from doing this?