aliend8k
10-31-2017, 05:12 AM
Hi forum. I posted a question the other day about a process to attempt to automatically lock a sheet after a digital signature is "removed", but still am unable to run a script that checks the form "change" status to automatically relock it. My form is locked, until the authorized signee runs the "signature" - in which it UNLOCKS the form to allow the digital signature to be added. The sheet will simply not allow the form to be locked - and signed - and I cannot find a good way to get this to work. Helpful tip was to add a Workbook_Open routine to make sure the form was locked on open, however, it runs into an error IF the form is already signed... it won't allow you to lock the signed form.
So my question is: Does anyone know if there is a way to SIMPLY deactivate or turn off the ability to REMOVE the digital signature "EDIT" that appears on the main menu which nullifies the signature (or at minimum - add a password to remove the signature)? If I was able to remove a general users ability to cancel the signature, the fact that the form is unlocked won't matter as much and only administrators could remove a signature if needed via password. I simply do not want a general user to gain access to the formulas and contents behind the locked cells (which are password protected when they get it to fill in the form), however, if they run the signature themselves, then cancel it - the form remains unlocked. Screen shot of the signed form - with the EDIT option that allows users to remove signature...
I tried to come up with a solution by checking the signature status (If ActiveWorkbook.Signatures.Count = 1 Then....); but I likely have the wrong code, in the wrong place to really get the Workbook_Change() to actually work (I'm not certain the ByVal Target is the right reference here), otherwise, it would run the ws.Protect to relock it on a change event...
thanks for any additional thoughts / input.
So my question is: Does anyone know if there is a way to SIMPLY deactivate or turn off the ability to REMOVE the digital signature "EDIT" that appears on the main menu which nullifies the signature (or at minimum - add a password to remove the signature)? If I was able to remove a general users ability to cancel the signature, the fact that the form is unlocked won't matter as much and only administrators could remove a signature if needed via password. I simply do not want a general user to gain access to the formulas and contents behind the locked cells (which are password protected when they get it to fill in the form), however, if they run the signature themselves, then cancel it - the form remains unlocked. Screen shot of the signed form - with the EDIT option that allows users to remove signature...
I tried to come up with a solution by checking the signature status (If ActiveWorkbook.Signatures.Count = 1 Then....); but I likely have the wrong code, in the wrong place to really get the Workbook_Change() to actually work (I'm not certain the ByVal Target is the right reference here), otherwise, it would run the ws.Protect to relock it on a change event...
thanks for any additional thoughts / input.