Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA

VBA

ResolvedVersion 2003

Fri 23 May 2008, 15:13 Delegate Michael said...

Michael has attended:
Excel VBA Intro Intermediate course

VBA

How can i set up a macro for duplex printing?

Thu 12 Jun 2008, 10:08 Trainer Carlos said...

RE: VBA

Hi Michael

As each printer has its own setup I would suggest you record a macro of yours printing the Excel document using Duplex printing.

This will give you the PrintOut properties and show you the relevant Duplex property.

Then just edit the code to be used on any document

Hope this helps

Carlos

Excel tip:

No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

VBA

VBA

RE: VBA

Excel articles

Excel tip:

No Zeros