![]() |
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