Excel Spreadsheet Protection

Hello,
I have a protected Excel spreadsheet that is available for use by a large
population. I would like to allow users to manupulate any saved copies.
Currently, when you save a copy to your personal desktop the protection is
still active and users can not make the spreadsheet their own. How do I
protect the original document but allow user manipulation of copies?
--
Michael J. Nowak
Energy Systems/Dow Chemical
Texas City, TX

Mike,
You could use the _BeforeSave event to check if it a .Save or .SaveAs.
If .Save, do nothing as it updating the original.
If .SaveAs, remove the protection of the worksheet(s) first.

NickHK

"Mike" <[email protected].(donotspam)> wrote in message
news:[email protected]...
> Hello,
> I have a protected Excel spreadsheet that is available for use by a large
> population. I would like to allow users to manupulate any saved copies.
> Currently, when you save a copy to your personal desktop the protection is
> still active and users can not make the spreadsheet their own. How do I
> protect the original document but allow user manipulation of copies?
> --
> Michael J. Nowak
> Energy Systems/Dow Chemical
> Texas City, TX

Nick, thanks for the reply. I am assuming you are talking about writing
macro code to checkthese conditions. I am not a real expert at that. Do you
have any more specific details on how I might accomplish this?
--
Michael J. Nowak
Energy Systems/Dow Chemical
Texas City, TX


"NickHK" wrote:

> Mike,
> You could use the _BeforeSave event to check if it a .Save or .SaveAs.
> If .Save, do nothing as it updating the original.
> If .SaveAs, remove the protection of the worksheet(s) first.
>
> NickHK
>
> "Mike" <[email protected].(donotspam)> wrote in message
> news:[email protected]...
> > Hello,
> > I have a protected Excel spreadsheet that is available for use by a large
> > population. I would like to allow users to manupulate any saved copies.
> > Currently, when you save a copy to your personal desktop the protection is
> > still active and users can not make the spreadsheet their own. How do I
> > protect the original document but allow user manipulation of copies?
> > --
> > Michael J. Nowak
> > Energy Systems/Dow Chemical
> > Texas City, TX
>
>
>