PrintPreview error when run from VBA
 

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

PrintPreview error when run from VBA
 

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

All is OK now

"Corey" wrote in message ...
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....