Macro to include Close Print Preview

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Macros with Print Preview 7
Closing Print Preview in Excel Macro 1
Print Preview Macro 7
Print Preview prints form not report 2
Print from preview 2
Printing a report/running the on close macro 1
Macro & Print Preview? 2
Print preview / full screen view problem 2

Back
Top