Share via

How can create a macro that will print to a specific printer and paper size.

Anonymous
2025-02-04T18:25:26+00:00

I am in a retail environment. I have a "Cashout" workbook that has 1 sheet per day of the month. We have 13 employees and they are all on one sheet. I am trying to make two buttons that will

  1. print/save a selection to a pdf on letter sized paper
  2. print a selection to a specific printer on a statement sized paper (5.5x8.5)

I created two macro buttons but if I print to paper then try to print to PDF it goes back to the printer. It basically prints with the last print settings.

A bonus would be to figure out how to list all the cheques taken by each clerk and the admin in the list of cheques section.

Microsoft 365 and Office | Install, redeem, activate | Other | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-02-05T08:54:59+00:00

    Hi Michelle A3717 ,

    Thanks for visiting Microsoft Community.

    I understand that you are experiencing problems with VBA. Since there is less involvement with VBA content in this community, it is recommended that you post your related questions on Stack Overflow (English Only) https://stackoverflow.com/questions/tagged/vba, where there are more experienced professionals who can offer you advice.

    Disclaimer: Microsoft makes no implied or other warranties, and is not responsible for information obtained from linked third-party websites or for any technical support related to technology provided by such sites.

    I will keep this topic open in anticipation of our wonderful volunteers who can provide guidance.

    Best Regards,

    Jonathan Z - MSFT | Microsoft Community Support Specialist

    0 comments