macro to print sheet2 without open sheet2
 

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

macro to print sheet2 without open sheet2
 

Use the following code :
Sheets("Sheet2").PrintOut
You don't need to activate the sheet.
HTH
Daniel
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