software

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?

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 quot;Before Savequot; 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, CABGx3quot;roel1973quot; wrote:

gt; Lets say I have a file that is on a shared drive that multiple users use. The
gt; file is not saved as a shared workbook. The file is password protected and
gt; all users know password. Is there a way to restrict the users from changing
gt; the password when they are re-protecting the workbook after they have made
gt; changes?
gt;
gt; I also have found that if I protect a work book some one who has the
gt; password can then protect and share the work book putting a new password over
gt; mine thus now not allowing me to edit the workbook. Is there any way to
gt; restrict users from doing this?

What should this quot;before savequot; macro and quot;secure amp; replacequot; macro look like?
Can you help me with that.

quot;CLRquot; wrote:

gt; Personally, in that situation, I think I would keep multiple secure backups
gt; of my own, to restore things as needed. In addition, I would investigate
gt; installing a quot;Before Savequot; macro that would, if necessary, copy all the data
gt; to a secure filename and save it with the proper password. This file can
gt; then be copied and re-named and placed for use.
gt;
gt; BTW, if everyone who uses the file knows the password, and must un-protect
gt; the file before using it..........what's the point of the password? Why not
gt; just put the file in a secure directory that only your approved users have
gt; access to?
gt;
gt; hth
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt;
gt;
gt; quot;roel1973quot; wrote:
gt;
gt; gt; Lets say I have a file that is on a shared drive that multiple users use. The
gt; gt; file is not saved as a shared workbook. The file is password protected and
gt; gt; all users know password. Is there a way to restrict the users from changing
gt; gt; the password when they are re-protecting the workbook after they have made
gt; gt; changes?
gt; gt;
gt; gt; I also have found that if I protect a work book some one who has the
gt; gt; password can then protect and share the work book putting a new password over
gt; gt; mine thus now not allowing me to edit the workbook. Is there any way to
gt; gt; restrict users from doing this?

Well, it got a little sticker than I thought..........In my XL97 I had to do
it this way.....
First, a quot;Before Savequot; macro to call a macro in a regular module

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Call UnProtectSheet
End Sub

Then, the macro in a regular module.........

Sub UnProtectSheet()
Cells.Select
Selection.Copy
Workbooks.Add
ActiveSheet.Paste
Range(quot;A1quot;).Select
Application.CutCopyMode = False
ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True, password:=quot;chuckquot;
ActiveWorkbook.SaveAs FileName:=quot;C:\MySecureFile.xlsquot;,
FileFormat:=xlNormal _
, password:=quot;quot;, WriteResPassword:=quot;quot;, ReadOnlyRecommended:=False, _
CreateBackup:=False
ActiveWindow.Close
Range(quot;a1quot;).Select
End Sub

I had to do it this way because for some reason the quot;Activesheet.pastequot;
statement would not work if the whole thing was put in the quot;Before Savequot;
module.......anyway, this works and when your user starts to save, even tho
he has protected the sheet with a different password than you wish, this
macro will copy the sheet to a new file called quot;MySecureFilequot; (which you can
change) and re-protect it with your old password (I used quot;chuckquot; in the code
which you can change). You can then copy it over the file that he saved with
his password if you wish.

hth
Vaya con Dios,
Chuck, CABGx3
quot;roel1973quot; wrote:

gt; What should this quot;before savequot; macro and quot;secure amp; replacequot; macro look like?
gt; Can you help me with that.
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; Personally, in that situation, I think I would keep multiple secure backups
gt; gt; of my own, to restore things as needed. In addition, I would investigate
gt; gt; installing a quot;Before Savequot; macro that would, if necessary, copy all the data
gt; gt; to a secure filename and save it with the proper password. This file can
gt; gt; then be copied and re-named and placed for use.
gt; gt;
gt; gt; BTW, if everyone who uses the file knows the password, and must un-protect
gt; gt; the file before using it..........what's the point of the password? Why not
gt; gt; just put the file in a secure directory that only your approved users have
gt; gt; access to?
gt; gt;
gt; gt; hth
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;roel1973quot; wrote:
gt; gt;
gt; gt; gt; Lets say I have a file that is on a shared drive that multiple users use. The
gt; gt; gt; file is not saved as a shared workbook. The file is password protected and
gt; gt; gt; all users know password. Is there a way to restrict the users from changing
gt; gt; gt; the password when they are re-protecting the workbook after they have made
gt; gt; gt; changes?
gt; gt; gt;
gt; gt; gt; I also have found that if I protect a work book some one who has the
gt; gt; gt; password can then protect and share the work book putting a new password over
gt; gt; gt; mine thus now not allowing me to edit the workbook. Is there any way to
gt; gt; gt; restrict users from doing this?