excel vba courses - printer control vba

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba courses - Printer control in vba

excel vba courses - Printer control in vba

resolvedResolved · Low Priority · Version Standard

Paul has attended:
Excel VBA Intro Intermediate course

Printer control in vba

can we use vba to tell printer to use colour?

RE: printer control in vba

Paul,

Essentially yes you can, however it will depend on whether your printer supports colour printing.

When I last did I wanted to print something from Access. The way I did this was to send the data to Word and using VBA and then use VBA printing/layout/format commands to create a nicely formatted printable page. When doing this, you can opt to use colours or just mono for the items you wish to print.
Hope this helps
David


 

Excel tip:

Changing the Tab Colour of an Excel 2010 Worksheet

Did you know you could give the tabs in your worksheet different colours?

This is particularly useful when organizing all your worksheets relating to a particular period or year, for example.

Right click a tab
Select Tab Colour
And choose your favourite colour!

View all Excel hints and tips


Server loaded in 0.09 secs.