ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel print macro error (https://www.excelbanter.com/excel-programming/285200-excel-print-macro-error.html)

Mosher

Excel print macro error
 
Hi all,

I have an Excel macro that is supposed to print certain fields but everytime
I click the control button to execute the macro, a dialog appears saying,
"Please put paper in the printer" (or something along those lines) and an
"OK" button. There is paper in the printer and after you click the "OK"
button, it prints fine. Itt is very annoying...and since there already is
paper in the printer, unecessary. Here is the code for the macro control
button:

Private Sub CommandButton1_Click()
Range("T1:AO250").Select
ActiveSheet.PageSetup.PrintArea = Selection.Address
ActiveWindow.SelectedSheets.PrintOut Copies:=1
End Sub

Any way to remove the annoying message?

Thanks,

Mosher








All times are GMT +1. The time now is 07:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com