+ Reply to Thread
Results 1 to 1 of 1

How to detect dialogs if cancel button was clicked

  1. #1
    Registered User
    Join Date
    07-08-2012
    Location
    Venezuela
    MS-Off Ver
    Excel 2010
    Posts
    62

    How to detect dialogs if cancel button was clicked

    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: 
    Last edited by necalabria; 05-24-2016 at 06:31 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Exit Sub when Cancel is clicked on Input Box
    By rtcwlomax in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2015, 01:57 PM
  2. [SOLVED] InputBox User Clicked Cancel
    By goss in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-05-2014, 03:19 PM
  3. [SOLVED] Userform Cancel button when clicked still inputs data
    By Mr_Bill in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-27-2014, 01:04 PM
  4. Is there a way to detect that a worksheet tab has been clicked?
    By kioolt in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-27-2014, 05:08 AM
  5. [SOLVED] If cancel button is clicked then exit sub problem!?
    By jeroenft in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2014, 08:34 AM
  6. [SOLVED] Detect which shape was clicked....
    By Thief_ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-15-2005, 12:05 AM
  7. [SOLVED] Detect which shape was clicked?
    By Thief_ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-14-2005, 11:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1