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
Excel VBA - Problem with Closing Print Preview 0
PrintPreview problem 3
PrintPreview of multiple sheets under Excel 2007 1
Print from PrintPreview macro method 2
print command from command button in userform causes double chart 5
userform and printpreview 2
Excel 2007 Print Preview 7

Top