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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Workbook Printing Problem 1
Printing a workbook but not getting page set-up results 1
Printing multiple worksheets in a workbook 3
Print Entire Workbook acting strangely 1
Duplex Printing of Workbook with multiple worksheets 2
Problem printing all worksheets in colour 1
Print worksheet 2 on back of worksheet 1, etc.... 1
Print 1

Back
Top