.PrintPreview

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

Guest

I need to go in and out of Excel's print preview by means of VBA. Help files
show me how to get in with "Sheets("").PrintPreview" but nothing on how to
get out?
 
The user must close the preview window
--
HTH,
Gary Brown
(e-mail address removed)
If this post was helpful to you, please select ''YES'' at the bottom of the
post.
 
It makes no sense to close the Printpreview from code.
How do you know the user has finished doing whatever it is that required the
preview in the first place ?

NickHK
 

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

Excel VBA - Problem with Closing Print Preview 0
print command from command button in userform causes double chart 5
Print from PrintPreview macro method 2
PrintPreview problem in 2007 1
PrintPreview error when run from VBA 1
Print Preview Freezes 1
PrintPreview problem 3
userform and printpreview 2

Back
Top