Macro to include Close Print Preview

V

Vic

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?
 
J

Jon Peltier

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/
_______
 

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

VBA word change keys 0
Print order of TriFold - Publisher 365 0
Office 2010, background images do not appear in print preview nor print 0
Table of content - format does not get saved 2
Need Help with Macro Security 1
Making a macro only work on certain files 2
Improving Macro That Keeps First Letter 0
Printing Outline view - formatting lost 0

Top