Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Macro to include Close Print Preview
I've written a macro that includes doing pagesetup in print preview and then
I included close print preview in the macro, but when I run the macro it ends with displaying the print preview. Is there anyway that I can change the VBA to close the window without having to rewrite my entire macro? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Macro to include Close Print Preview
You can't close the print preview, the user has to do that.
Do you want to change print preview settings? You can do that without displaying print preview. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Vic" wrote in message ... I've written a macro that includes doing pagesetup in print preview and then I included close print preview in the macro, but when I run the macro it ends with displaying the print preview. Is there anyway that I can change the VBA to close the window without having to rewrite my entire macro? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
my Excel chart doesn't print as it appears on print preview | Excel Discussion (Misc queries) | |||
Excel cell looks good in print preview but doesn't print??? | Excel Discussion (Misc queries) | |||
Can't print diagonal borders although they show on print preview | Excel Discussion (Misc queries) | |||
Print Preview in Grayscale | Excel Discussion (Misc queries) | |||
Macro for changing print settings | Excel Discussion (Misc queries) |