Hi All........
If this is possible, I could use some help please.
1-User opens file and un-protects with password, and makes changes to sheet.
2-Tools > Protection selection is disabled so user cannot re-invoke
Protection and insert their own password.
3-Before-save macro re-enables the Tools > Protection selection and invokes
Sheet Protection with "MyOriginalPassword"

Any help/suggestions would be appreciated
Vaya con Dios,
Chuck, CABGx3

sheet level protection is so easily broken, just put code in your project to
break the password and reset it.

http://www.mcgimpsey.com/excel/removepwords.html

--
Regards,
Tom Ogilvy




"CLR" wrote:

> Hi All........
> If this is possible, I could use some help please.
> 1-User opens file and un-protects with password, and makes changes to sheet.
> 2-Tools > Protection selection is disabled so user cannot re-invoke
> Protection and insert their own password.
> 3-Before-save macro re-enables the Tools > Protection selection and invokes
> Sheet Protection with "MyOriginalPassword"
>
> Any help/suggestions would be appreciated
> Vaya con Dios,
> Chuck, CABGx3
>
>

Thanks Tom.......that got me to where I needed to be.

Vaya con Dios,
Chuck, CABGx3



"Tom Ogilvy" wrote:

> sheet level protection is so easily broken, just put code in your project to
> break the password and reset it.
>
> http://www.mcgimpsey.com/excel/removepwords.html
>
> --
> Regards,
> Tom Ogilvy
>
>
>
>
> "CLR" wrote:
>
> > Hi All........
> > If this is possible, I could use some help please.
> > 1-User opens file and un-protects with password, and makes changes to sheet.
> > 2-Tools > Protection selection is disabled so user cannot re-invoke
> > Protection and insert their own password.
> > 3-Before-save macro re-enables the Tools > Protection selection and invokes
> > Sheet Protection with "MyOriginalPassword"
> >
> > Any help/suggestions would be appreciated
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >