Print Preview

MikeDBMan

Well-known Member
Joined
Nov 10, 2010
Messages
583
I have several subs where I create a temporary spreadsheet and display data in a print-preview mode. The user can then print the data or just press escape to continue on. My issue: sometimes the mouse cannot click anything on the screen. The only thing I can do is press the {ESC} key to escape. But the very next time the exact same code is executed and I have full mouse control. Anyone have any ideas about this?
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

bensonsearch

Well-known Member
Joined
May 26, 2011
Messages
844
hi,
never really seen that before but I do know that print preview pops up as modal, no way around that unfortunately. It may have something to do with it, do you have sample code?
 

Watch MrExcel Video

Forum statistics

Threads
1,099,773
Messages
5,470,698
Members
406,718
Latest member
waseem11

This Week's Hot Topics

Top