Print Help

  • Thread starter Thread starter itty
  • Start date Start date
I

itty

I am having a file with 22 pages. How can I print all this in one click
Please Help.
Thank
 
try this

Sub printwb()
ActiveWorkbook.PrintOut
End Sub
--
Don Guillett
SalesAid Software
(e-mail address removed)
itty said:
I am having a file with 22 pages. How can I print all this in one click?
Please Help.
Thanks


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
creating financial statements
 
-File>Print
-Under "Print What", select "Entire Workbook"

Hope this helps,

--
George Nicholson

Remove 'Junk' from return address.

itty said:
I am having a file with 22 pages. How can I print all this in one click?
Please Help.
Thanks


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
creating financial statements
 
Back
Top