C
Corey C.
I have a VFP9.0 application that uses an Excel 2003 workbook for a portion of
the user data entry. Because of the complexity of the workbook, the print
functionality per worksheet is automated using VBA code. To remove the
screen flicker in the custom print function the Application.ScreenUpdating
property is set to False until after the custom print is finished (either the
user prints the report or closes out of print preview).
In our upgrade to Excel 2007, it was discovered that shutting off the
ScreenUpdating property would keep the ribbon bar from updating and changing
to the print preview ribbon bar during this custom function. This would
leave the user with out any way to do anything in the print preview screen,
unless they knew the keyboard commands. With out the proper ribbon bar being
available the only way out of the the print preview screen is to 'Esc'ape out.
Because the print function is embedded in VBA code within the same workbook
that the users are doing their data entry, replacing the workbook with a new
one that has the code fix is impossible.
My current idea of a fix is to Bind to a VBA event using VFP code to set the
ScreenUpdating property to True right before the print preview screen is
shown. However I can't find the right VBA event to bind to. Any suggestions
would be greatly appreciated.
Thanks,
Corey C.
the user data entry. Because of the complexity of the workbook, the print
functionality per worksheet is automated using VBA code. To remove the
screen flicker in the custom print function the Application.ScreenUpdating
property is set to False until after the custom print is finished (either the
user prints the report or closes out of print preview).
In our upgrade to Excel 2007, it was discovered that shutting off the
ScreenUpdating property would keep the ribbon bar from updating and changing
to the print preview ribbon bar during this custom function. This would
leave the user with out any way to do anything in the print preview screen,
unless they knew the keyboard commands. With out the proper ribbon bar being
available the only way out of the the print preview screen is to 'Esc'ape out.
Because the print function is embedded in VBA code within the same workbook
that the users are doing their data entry, replacing the workbook with a new
one that has the code fix is impossible.
My current idea of a fix is to Bind to a VBA event using VFP code to set the
ScreenUpdating property to True right before the print preview screen is
shown. However I can't find the right VBA event to bind to. Any suggestions
would be greatly appreciated.
Thanks,
Corey C.