Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Handling Print Preview Event
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print preview v page break preview | Excel Discussion (Misc queries) | |||
checkbox event handling function | Excel Worksheet Functions | |||
On Event calendar with error handling? | Excel Programming | |||
Event handling... | Excel Programming | |||
excel object event handling | Excel Programming |