macro to print sheet2 without open sheet2

R

ramzi

hi,
i have page to print in sheet1 and my macro in sheet 1.
how i'm going to print sheet 2 using macro without opening sheet2 by click
on macro button at sheet1

thanks

rgds
 
D

Daniel.C

Use the following code :
Sheets("Sheet2").PrintOut
You don't need to activate the sheet.
HTH
Daniel
 
Top