Print Help

I

itty

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

Don Guillett

try this

Sub printwb()
ActiveWorkbook.PrintOut
End Sub
--
Don Guillett
SalesAid Software
[email protected]
itty said:
I am having a file with 22 pages. How can I print all this in one click?
Please Help.
Thanks
creating financial statements
 
G

George Nicholson

-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
creating financial statements
 
Top