printpreview is messing up my Sub Workbook_BeforePrint(Cancel As Boolean) macro

Posted by blake on February 13, 2002 11:25 AM

i have userform appear beforeprint that displays some information, but if you select printpreview the user forma appears only to "lock up" excel no matter what you do. does anyone know how to get around this? thanks

Posted by Jim on February 13, 2002 12:47 PM

Hi Blake,

A wild guess, is your userform modal or modeless?
If modal this could possibly be causing the problem

Jim