setting print preferences on multiple tabs

J

jools

I have a client who only accepts single sided prints. When i have a workbook
with multiple tabs how do I change the print preferences for the entire
workbook. At the moment I have to go to each tab and change the print
preferences individually which is taking ages!
 
S

Stout

Have you tried grouping all the tabs together, then setting your preferences?

click on the 1st tab, scroll to the last tab, holding down the sift key,
click the last tab
 
J

jools

Yes

tried this and it doesn't work unfortunately

I am sure there must be a way of doing it though
 
D

Dave Peterson

What property didn't work?

Lots of them do get changed if you group the sheets first. Some can't be.

The only alternatives are to do it one-by-one or to create a macro that does
what you want to each sheet.

Recording a macro when you do it once could be useful.
Eliminate the things you don't want to change.
And tweak the macro to cycle through all(?) the worksheets in the workbook.

(or run that same macro against each worksheet via tools|macro|macros)
 
Top