Printing multiple sheets.

  • Thread starter Thread starter sungen99
  • Start date Start date
S

sungen99

You guys are so helpful. This is my current dilemma.

I have already set up 3 different worksheets within one workbook.
have already done the page setup and make all my margins and such loo
perfect.

My macro stuff resides on the 4th sheet of the workbook. what I woul
like to happen when you press the “go” button is for worksheet 1, 2
and 3 to print.

Can anyone tell me how this would be done?

Thanks again in advance
 
Use this

Sheets(Array("Sheet1", "Sheet2", "Sheet3")).PrintOut
 
You must log in or register to reply here.

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

Macro for all Excel Workbooks to print to PDF 2
Applying a specific Print setting to all worksheets 1
Print only the used sheets in all open files 2
Copying cells and formula from closed workbook to all sheets in open workbook 0
Creating a new workbook. 2
How to restrict printing certain sheets 2
Excel crashes and restarts when accessing newly created worksheet 2
Email selected sheets 5

Back
Top