+ Reply to Thread
Results 1 to 12 of 12

print button

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    print button

    Hello to all.
    In the attached file I added a button to print the sheets
    In ThisWorkbook I inserted a macro that disables printing.
    The editing that I ask, if you can, is that you can print using
    only the button and not inserted from the toolbar.
    I hope I explained.
    max_max

    stampa_pulsante.xls

  2. #2
    Valued Forum Contributor Gatti's Avatar
    Join Date
    06-08-2015
    Location
    Brasil, São Paulo, Ribeirão Preto
    MS-Off Ver
    365
    Posts
    346

    Re: print button

    Hello my friend

    Try doing these changes:

    First: Change your buttom for one retangle shape (don't use ActiveX)

    Do this macro on Module1

    Please Login or Register  to view this content.
    Clear all macros on Workbook and Worksheets VBE Pages

    Insert this macros into Workbook VBE Page:

    Please Login or Register  to view this content.
    Give your retangle shapes the ButtonClick Macro

    Restart your application

    Try to print

    The sample:
    Attached Files Attached Files

  3. #3
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: print button

    Olá Gatti .
    Obrigado, muito obrigado, é como procurar.
    Saudações,
    max_max

    (I hope the translation is accurate.)

  4. #4
    Valued Forum Contributor Gatti's Avatar
    Join Date
    06-08-2015
    Location
    Brasil, São Paulo, Ribeirão Preto
    MS-Off Ver
    365
    Posts
    346

    Re: print button

    Haha got the translation

    Spero che risolto
    sinceramente,
    Fábio Gatti

    Btw: If your problem is solved, mark the thread as [SOLVED] and, if possiblem add reputation

  5. #5
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: print button

    @ Gatti,

    Nice work!!!
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  6. #6
    Valued Forum Contributor Gatti's Avatar
    Join Date
    06-08-2015
    Location
    Brasil, São Paulo, Ribeirão Preto
    MS-Off Ver
    365
    Posts
    346

    Re: print button

    Thanks, @Winon

  7. #7
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: print button

    Hello Fabio.
    I made some changes but the macro "STAMPA 2" (foglio1/sheet1) with your changes will not work.
    A help?
    I attach an example.
    max_max
    Attached Files Attached Files
    Last edited by max_max; 02-06-2016 at 10:47 AM.

  8. #8
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: print button

    Hello,
    the new attached, there are two macros in the sheet1 for printing and only STAMPA1 works.
    max_max


    stampa_solo_con_pulsate_new.xls

  9. #9
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: print button

    Hello to all,
    I solved it by changing here:


    Please Login or Register  to view this content.

    I hope it is the exact solution.
    A greeting,
    max_max

  10. #10
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: print button

    Hello max_max,

    If that works for you, well done!

    I was going to suggest the following:

    Please Login or Register  to view this content.
    I cannot say that it is better than your own solution, but yes, it does show another alternative.

    Regards.

  11. #11
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: print button

    Thanks you Winon.
    Also good is your solution.
    Thank you.
    A greeting.
    max_max

  12. #12
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: print button

    Hi max_max,

    Thank you for the feedback, and your approval.

    It took me a while to get around Italian, hence the late response,

    Kind regards.

+ 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. VBA code to create command button. Print all sheets then delete command button.
    By Declamatory in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-15-2015, 05:18 PM
  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. Replies: 0
    Last Post: 06-10-2014, 10:44 PM
  4. Disable Print button in Full Print Preview
    By RaquelAR in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-17-2013, 02:03 PM
  5. [SOLVED] Print only current page! Not all 47 pages when print button is pressed?
    By Margate in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-11-2013, 10:06 AM
  6. Print Button to print UserForm for multi-sheet
    By smartcard in forum Excel General
    Replies: 12
    Last Post: 04-29-2010, 07:47 AM
  7. Print button to print userform
    By jcarstens in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-20-2009, 08:18 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