macro to print sheet2 without open sheet2

  • Thread starter Thread starter ramzi
  • Start date Start date
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
 
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
Appointments, Perpetual Calender 2
copy data from sheet2 to sheet1 when sheet2 has variable # of rows 6
Macro: Copy data to another sheet 3
Range(sheet2) = Range(sheet1) 11
Go to next cell if full 2
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Macro to replace in two worksheets 5

Back
Top