Print...

Home Search Site Map

Up
Close
Exit
File Search...
Most Frequently Used
New...
Open...
Page Setup...
Permission
Print...
Print Area
Print Preview
Properties
Save
Save As...
Save as Web Page...
Save Workspace...
Send To
Web Page Preview

New! Excel User Group Now Open @ www.excelusergroup.org, Check It Out!


Menu command Type What happens next?
Print... ...

This selection will produce the print dialog. (Below)

This is an Excel dialog but interacts with the print driver.  It allows settings such as number of copies, whether you wish to print the current sheet, current selection, or entire workbook and which pages you want to print. You can also change the printer via the 'Name' drop-down and access all the printer's settings by pressing the 'Properties' button. If you access 'Print' from the standard toolbar button, it simply starts printing using the default printer, no dialog is shown.

VBA Sub SheetPrintOut()
Dim mySheet As Worksheet
Set mySheet = ActiveSheet
'Printout 2 copies
mySheet.PrintOut Copies:=2
End Sub

Top

Copyright Nick Hodge 2008. All Rights Reserved.