printer macro

  1. F

    Print Macro

    I am looking for a MACRO that when you click on a "PRINT BUTTON" a message will pop up telling the user to "Load Legal size paper in front of printer, Click OK to print page one...." From there it will print page one of the sheet and then a message will pop up to load second sheet of Legal...
  2. B

    vba experts could someone help me get this code in order

    I am trying to make this macro print do to a specified printer. I recently found some code on the forum to have it choose the printer I need but I have it at the bottom of this code and I think it needs to be at the top because I need to choose the paper size and keep the other settings. It...
  3. J

    VBA printer code help needed!

    The below code opens up the printpreview window. This does not allow to select the correct (or change) printer it will automatic use the default printer. Is there a way for the code to open the print window so I can change the printer and select number of copies? Sub Print_Button() Dim...
  4. A

    Hide Column When Printing

    I need to print a area but hide some column each time I print. I get an error message with this. Can someone help me fix this macro? I want to Hide column K &L, and then unhide after I print. Sub print_route() .Columns("K:L").EntireColumn.Hidden = True ActiveWindow.SelectedSheets.PrintOut...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top