Need to Exit Sub when Signature Line is signed

[kanneb]

Hello,

I am quite new to VBA and new to this forum so hopefully I am explaining my requirements properly. I am using both Excel 2007 and Excel 2016.

I am creating a Private Sub that runs automatically when the workbook is opened. My code does everything that I need it to but we use the Signature Line for approvals. Once the file is approved and is signed, Excel automatically saves the file to Read Only and prevents any edits. If I re-open a file after it is signed, I need for the code to exit the sub instead of executing it, if I don't then the user will get an error because the macro fails.

I have added the code, which worked if I flagged the file as read only but didn't work if it was Read Only because it was signed.

Please Login or Register  to view this content.

I did some searching online and replace the first line above with the line below:

Please Login or Register  to view this content.

This resulted in a Run Time Error "438" Object does not support this property or method.

Over the last few hours I have done more searching (and tried several variations of the above) but can't seem to find very much VBA code relating to the use of the Signature Line function included in Excel.

Any help would be greatly appreciated.

Thank you.

[leelnich]

Hi kanneb, welcome to the forum! I don't work with signatures, so I'm only guessing, but perhaps:

Please Login or Register  to view this content.

[mehmetcik]

Welcome to the forum.

Unfortunately you have not read the rules and will therefore not get any responses.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[kanneb]

My apologies. I have fixed my post.

[kanneb]

Thank you for the suggestion. It seems to have worked exactly the way I was hoping.

Hi kanneb, welcome to the forum! I don't work with signatures, so I'm only guessing, but perhaps:

Please Login or Register  to view this content.

[leelnich]

Sure, happy to help. That property popped up when I googled "workbook signatures".