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, Computer Software Engineer
Category: Computer
Satisfied Customers: 52
Experience:  Master degree in computer science engineering
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: 1 year ago.
Category: Computer
Expert:  fbeltramini replied 1 year ago.

Hello. Are you using Microsoft Excel for Mac?

Customer: replied 1 year ago.
I am
Expert:  fbeltramini replied 1 year ago.


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
End Sub

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


Customer: replied 1 year ago.
Thank you.
Expert:  fbeltramini replied 1 year ago.

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

Expert:  fbeltramini replied 1 year 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!