Tech Support Guy banner

Printing every other page of an entire workbook

835 Views 3 Replies 2 Participants Last post by  DaveA
I am trying to write a macro that will allow me to print either only the first or second page of the 30 or so Sheets I have in an open workbook. I found how to print the second page of an open sheet and how to print all pages of the workbook but I need help combining the two! I am using this for activity sheets on the first page that are printed at the beginning of the week and the time cards on the second that are printed at the end.
Status
Not open for further replies.
1 - 4 of 4 Posts
What spread sheet program and version are you using?

What printer and model are you using?
I am using Excel 2010 for Mac. The printer may change but right now it is a Brother HL 5240.
Things like this are normally controlled within the settings of the printer driver and software.
Not sure if these settings can be accessed when using a macro?
1 - 4 of 4 Posts
Status
Not open for further replies.
Top