Handling Print Preview Event

[Corey C.]

I have a VFP application that uses Excel Workbooks for a portion of the data
entry by the end user. The spreedsheets used by the application are complex
enough that it was decide to automate the print preview function for the user.

Using VBA code the print area and other printer settings are set before
sending the user to the print preview screen.

The problem is that when this code was written in Excel 2003 to ride the
user of annoying screen flicker the Application.ScreenUpdating property was
set to False until after the preview process was completed. Actually the
ScreenUpdating property is not set back to True until after exiting the print
preview screen, either by printing or close.

In Excel 2007 turning off ScreenUpdating in this process will keep the
Ribbon Bar from updating as well, leaving the end user in the Print Preview
screen with out the standard Print Preview Ribbon Bar. This forces the user
to either use key board commands to send the out put to the printer or Escape
out of the screen.

I'm attempting to write an Event binding handler in the VFP code to set the
ScreenUpdating back to True prior to the Print Preview screen becoming the
active screen in hopes that this will allow the Ribbon Bar to update
properly, giving the end user the proper Ribbon Bar buttons and commands to
use.

Any help would be greatly appreciated.

Corey C.