View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mosher Mosher is offline
external usenet poster
 
Posts: 1
Default 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