Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coding for printing (without preview)
Sub printall()
For i = 1 To 6 [c1] = i ActiveSheet.PrintPreview Next [c1] = 0 End Sub This piece of coding will printout a filtered chart. My problem is that it previews the chart and then you have to click the print button to print. I don't want that. I would like it to print without previewing. I have run the code without the word printpreview and it still doesn't work. Any help is appreciated. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coding for printing (without preview)
Peter,
Try ActiveSheet.PrintOut -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Peter McCaul" wrote in message ... Sub printall() For i = 1 To 6 [c1] = i ActiveSheet.PrintPreview Next [c1] = 0 End Sub This piece of coding will printout a filtered chart. My problem is that it previews the chart and then you have to click the print button to print. I don't want that. I would like it to print without previewing. I have run the code without the word printpreview and it still doesn't work. Any help is appreciated. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Image distortion during printing and preview | Excel Discussion (Misc queries) | |||
Excel VBA Coding for Printing | Excel Discussion (Misc queries) | |||
Print Preview does not allow printing | Excel Discussion (Misc queries) | |||
how do I fix printing-able to see as preview, but print out blank | Excel Discussion (Misc queries) | |||
not printing same as preview | Excel Discussion (Misc queries) |