Supress print dialogue without suppressing userform updates!

[Glory]

I found a great way to supress "Now Printing" dialogue windows here.

But there's a problem. I'm using a "progress bar" userform to show the progress of a macro.

For some reason the function shown above prevents the userform from updating, instead of just preventing the "Now Printing" dialogue windows from popping up.

Here's an example of the sort of code I'm running:

For i = 1 to 10
 
    fncScreenUpdating False
    Sheet1.PrintOut
    fncScreenUpdating True
 
    ProgressBar = i * 20
    Label1.Width = ProgressBar
 
Next

Does anyone have any suggestions about how I should modify that UDF up top?

 

[Glory]

http://www.cpearson.com/excel/formcontrol.aspx

I'm checking on that last idea now.

"Returns the window handle (HWnd) of a user form"

Maybe there's a way to exclude the HWnd of a particular form from being affected by that macro?