Excel print macro error

M

Mosher

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to print plus list options? 2
Print macro help 3
Simple Macro freezes the whole Excel and PC! 5
vba - printing code 4
How to program print preferences 2
Problem w/ Print Macro 3
Assigned macro in Dialog giving error 9
Print Excel Directly to Printer 6

Top