Hi -

I've put together a userform which allows my stores to perform
multiple tasks ... thanks to all of you whose posts were pieced
together to create this beauty! ;)

One of the tasks is a print-out of filtered data ... the nature of the
data requires that it be formatted 'live' (eg, auto-fitting columns,
etc). This all works great, but takes about 15-20secs to complete, so
I'd like to have a 2nd userform pop up to indicate that the Print
macro is running ... when that's done, the 2nd userform should close
and a 3rd one will appear to indicate that the Printout is complete.
2nd userform has no 'close' function (X is disabled), 3rd userform has
a 'done' button to close the form.

I've built the userforms and successfully opened the 2nd userform at
the start of the Print macro. However, that userform never closes and
the 3rd one never opens! What am I doing wrong?

to open 2nd userform: Prnting.Show
[...formatting and printing code...]

Unload Me
PrintDone.Show

End Sub

TIA, Ray