How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask fbeltramini Your Own Question

fbeltramini
fbeltramini, Computer Software Engineer
Category: Computer
Satisfied Customers: 52
Experience:  Master degree in computer science engineering
75751351
Type Your Computer Question Here...
fbeltramini is online now
A new question is answered every 9 seconds

I am trying to print to Worksheets in one Workbook at the

Customer Question

I am trying to print to Worksheets in one Workbook at the same time. I am printing double-sided. The first sheet is 3 pages long and the second is only 2. How can I print double-sided but have the second worksheet start on a new page?
I know this seems silly for a small job, but this is just a small example of the number of documents I need to print at once. Just trying to see if there is a quicker way than clicking on one sheet at a time and printing.
Submitted: 10 months ago.
Category: Computer
Expert:  fbeltramini replied 10 months ago.

Hello. Are you using Microsoft Excel for Mac?

Customer: replied 10 months ago.
I am
Expert:  fbeltramini replied 10 months ago.

Perfect.

You need to create a VB macro and insert this code inside the macro routine:

Sub PrintAllSheets()
Dim i As Integer
For i = 1 To Worksheets.Count
Worksheets(i).PrintOut
Next
End Sub

Then you can associate the macro to your favourite key combination to activate it.

Fabio

Customer: replied 10 months ago.
Thank you.
Expert:  fbeltramini replied 10 months ago.

Please don't forget to rate my service if you appreciated it.

Expert:  fbeltramini replied 10 months ago.

I still not received your feedback in this question. Please consider rating my service either in case you are satisfied or not otherwise I'll not be compensated for the time spent supporting your request. Thanks!