Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print preview error from BeforePrint macro | Excel Discussion (Misc queries) | |||
Error using a macro to print multiple pages. | Excel Discussion (Misc queries) | |||
Print Macro Error | Excel Worksheet Functions | |||
Why do I get a print error light trying to print an excel sheet ? | Excel Discussion (Misc queries) | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) |