| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA print preview hangs Excel
I'm using Excel 2003 SP2.
I have a non-modal form that has among other things, a button that when clicked has this code: Worksheets(<sheet name).PrintPreview When I click on this button, the print preview appears as expected, but Excel hangs completely. Any click on the Excel window or the VB editor window or the form results in just a beep. It almost acts as if there were a modal window open, but there is none. I can no longer alt-tab to either Excel or the VB editor. I have to kill it with the Task Manager. What am I doing wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save as PDF not same size as Print and Print Preview in Excel | Excel Discussion (Misc queries) | |||
| First page of Excel sheerepeats in print layout or print preview | Excel Discussion (Misc queries) | |||
| my Excel chart doesn't print as it appears on print preview | Excel Discussion (Misc queries) | |||
| Why does macro speed slow after Excel Print or Print Preview? | Excel Programming | |||
| Print Preview hangs | Excel Programming | |||
Threaded Mode
