.PrintPreview
 

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

.PrintPreview
 

The user must close the preview window
--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"André Boileau" wrote:

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

.PrintPreview
 

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

"André Boileau" wrote in message
...
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?
--
Popsie