PrintPreview error when run from VBA

C

Corey

I have just upgraded to 2007, but found that i have code that populates a sheet with data from
another sheet, then shows the sheet/s in PrintPreview mode.
The problem is there is NO WAY to EXIT the Print Preview mode in Excell 2007.

I have to Use the CTRL + ALT + DEL to shut excel down to exit Print Preview mode.

Is there a work around ?

Corey....
 
C

Corey

Found how to ADD the Close PrintPreview button to the menu bar.

All is OK now

I have just upgraded to 2007, but found that i have code that populates a sheet with data from
another sheet, then shows the sheet/s in PrintPreview mode.
The problem is there is NO WAY to EXIT the Print Preview mode in Excell 2007.

I have to Use the CTRL + ALT + DEL to shut excel down to exit Print Preview mode.

Is there a work around ?

Corey....
 

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

PrintPreview problem in 2007 1
Publisher adding blank page when printing my booklet... 2
PrintPreview problem 3
Excell Otpions in office environment 0
Word 2007 flash screen upside down and Word2007 cannot be used 0
PrintPreview of multiple sheets under Excel 2007 1
Print from PrintPreview macro method 2
PrintPreview in 2007 (for what it's worth...) 0

Top