P
Paul Pedersen
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?
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?