Solved: Is there a way to have code trigger an event when trying to save or print?
Short version:
I want to generate an error message when certain fields are not filled in when the user tries to save or print the document.
Slightly longer version:
Still working on the same workbook with the pdf code (http://vbaexpress.com/forum/showthre...492#post103492 )
What I want to do, is make sure that certain fields are always filled (correctly) in before the user can print/save the document.
I want it to check only a few cells, three dates and a version number (1.2 etc)
If the cells are not filled in (correctly) by leaving them empty, or entering text, or only 1 number instead of 2 (for the version number), and they hit save/print (or try to pdf) the a popup error should appear saying that the dates or the version number has not been filled in correctly.
Is this a possibility?