can i reset the print options to always print the entire workbook

Consider declaring one command Macro and assign a ShortCut to it.
==================
Sub Print_Whole_WB()
ActiveWorkbook.PrintOut
End Sub
=======
Micky

"glenn" wrote:

can i reset the print options to always print the entire workbook

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.

"מיכ�ל (מיקי) �בידן" wrote:

Consider declaring one command Macro and assign a ShortCut to it.
==================
Sub Print_Whole_WB()
ActiveWorkbook.PrintOut
End Sub
=======
Micky

"glenn" wrote:

can i reset the print options to always print the entire workbook

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


On Sat, 5 Dec 2009 08:35:01 -0800, glenn
wrote:

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.

"????? (????) ?????" wrote:

Consider declaring one command Macro and assign a ShortCut to it.
==================
Sub Print_Whole_WB()
ActiveWorkbook.PrintOut
End Sub
=======
Micky

"glenn" wrote:

can i reset the print options to always print the entire workbook