| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable ability to Protect
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable ability to Protect
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable ability to Protect
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is it possible to disable the ability to save a file unless the u. | Excel Discussion (Misc queries) | |||
| Disable Tools Protection Protect Sheet for all users but one | Excel Discussion (Misc queries) | |||
| Disable Tools, Protect, Protect Workbook | Excel Programming | |||
| Disable/Protect Cells based on If | Excel Programming | |||
| combo box web ability | Excel Programming | |||
Linear Mode
