printing

  • Thread starter Thread starter glenn
  • Start date Start date
Consider declaring one command Macro and assign a ShortCut to it.
==================
Sub Print_Whole_WB()
ActiveWorkbook.PrintOut
End Sub
=======
Micky
 
Thanks Mickey. Is the macro part of the workbook? or a separate executable?
Can the shortcut be placed on the desktop? I have Excel non-users that may
need to print out this workbook to fill in blanks.
 
glenn

You cannot run a macro from a desktop shortcut or from a command line.

Your best bet to always print the entire workbook.............one workbook
only..........is to have beforeprint event code.

For Excel 2003 and earlier...............

With your workbook open right-click on the Excel Icon just left of File on
the menubar.

Select "View Code"

Paste this into that module.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveWorkbook.PrintOut
End Sub

Alt + q to return to Excel. Save the workbook.


Gord Dibben MS Excel MVP
 
Back
Top