MrExcel.com - Your One Stop for Excel Tips & Solutions

PRINT BY USING A MACRO

Posted by MOI on June 29, 2001 4:53 AM

Can somebody tell me how to let Excel print automatically by using a macro? It has to print the first sheet which is called "orderbon". I hope someone can help me with this one. Thanks already.

MOI

Posted by Ron on June 29, 2001 5:18 AM

You could try something like this.
Sheets("orderbon").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1

Posted by MOI on June 29, 2001 1:43 PM

THANKS IT WORKS!!!!

Thanks for your advice! It's working now!

MOI