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
 

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

Excel VBA to move cells to sheet2 based on selection in sheet1 0
Macro: Copy data to another sheet 3
Range(sheet2) = Range(sheet1) 11
copy data from sheet2 to sheet1 when sheet2 has variable # of rows 6
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Macro-indirect cell 4
Appointments, Perpetual Calender 2
move blank data 10

Top