Hello, My Friends:
I have a workbook with several sheets, some of which are going to be printed at once, eighther to a .pdf file or to a paper. Doing so, there are several dialogs that are shown, for example:
Dialog PrinterSetup to choose the printer.
Dialog Save PDF file as, in the case of a .pdf, to choose where to save the document.
Dialog Confirm Save to confirm the operation, of course.
Dialog Adobe PDF that shows the addition of sheets to the final document.
I am not sure, but only the first one is really an Application.Dialogs, the others are not, at least they do not appear in the VBA list as one.
All of the dialogs have a "Cancel" button, to cancel the printing. My code can detect if the Dialog PrinterSetup Cancel button has been clicked, but that it is. I DO NOT KNOW HOW TO DETECT if SOME OF THE OTHER IS PUSHED. I need help to figure out this.
Here is my code:
HTML Code:
Bookmarks