Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bind Event Prior to Print Preview
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Handling Print Preview Event | Excel Programming | |||
Print and Print Preview Graphic Moving Resizing 2007/2003 | Excel Discussion (Misc queries) | |||
print preview v page break preview | Excel Discussion (Misc queries) | |||
cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) | |||
Re-bind built-in Excel functionality to new OnKey event. | Excel Programming |