+ Reply to Thread
Results 1 to 3 of 3

stop print with macro

  1. #1
    Forum Contributor
    Join Date
    08-27-2019
    Location
    europa
    MS-Off Ver
    excel 2007
    Posts
    456

    stop print with macro

    Greetings,
    in the attached workbook there are 2 buttons

    stampa/print
    stampa/ print with userform

    if I click on print the sheets will start printing
    here if I want to interrupt the printing I click ESC and a message appears to interrupt Yes or No

    if I click on print with userform, userform1 is displayed, I click on the print button and the printing of the sheets starts
    here if I want to stop printing and I click ESC I don't see a message to stop Yes or No

    how to edit macro in userform to abort with ESC?


    I hope I explained myself, thanks
    Attached Files Attached Files
    Last edited by xam99; 03-29-2024 at 11:43 AM.

  2. #2
    Registered User
    Join Date
    03-12-2022
    Location
    Argentina
    MS-Off Ver
    2016
    Posts
    26

    Re: stop print with macro

    try this,
    Unloading Form and call the first button.

    print_userform_2.xlsm

  3. #3
    Forum Contributor
    Join Date
    08-27-2019
    Location
    europa
    MS-Off Ver
    excel 2007
    Posts
    456

    Re: stop print with macro

    Hi danny44,
    thanks I think that's correct

+ 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] Excel Macro to print selection when cell value is entered - won't stop printing
    By pepinjs in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-10-2022, 10:34 AM
  2. Disabled print toolbar and menu but Print Macro button cannot print also...
    By zein97 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-22-2014, 01:42 PM
  3. [SOLVED] Stop Print If conditon are not met
    By robrobet in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-30-2013, 01:35 PM
  4. stop rather than print
    By stevesunfold in forum Excel General
    Replies: 0
    Last Post: 03-19-2010, 08:37 AM
  5. How to stop print in blank cell?
    By Wind54Surfer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-03-2006, 04:10 PM
  6. Replies: 0
    Last Post: 09-19-2005, 03:05 PM
  7. Replies: 1
    Last Post: 04-11-2005, 06:06 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