View Single Post
 
Old 12-12-2025, 12:23 AM
PDanes PDanes is offline Windows 10 Office 2021
Novice
 
Join Date: Dec 2020
Posts: 12
PDanes is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
There are other document events that you could use.
Presumably the document gets saved - there is an event for DocumentBeforeSave for instance
Or DocumentBeforePrint

If you are putting the Excel content into Content Controls you could also use Document_ContentControlBeforeContentUpdate
I've looked at other document events, and none seemed to fit my situation. The BeforeClose or BeforePrint might work, but the doc would be in an incorrect state until that happened. I don't want that - the user might screen-shot the doc, or use his phone to snap an image and send that off. I want the doc to be correct always, or as always as possible. Sure the user could make a snap after changing text in a field, but before leaving the field, but I can't babysit every possible situation.

However, Content Controls sound promising. I've never worked with them - most my intensive programming with Word was years ago, but I'll have a look. Thank you for the idea.
Reply With Quote