Yesteday, I wrote this question:

I have a UserForm on a worksheet that I want to go away when I click the
Print Preview button, but reappear in the same position that is was before
the PP button was clicked.

The answer that I received was:

Try to hide it using "yourform.hide" before the print preview followed by
"yourform.show" when the print preview has completed.

How will I know when the user click the close button from the print preview
of the workbook? I can't seem to find how I would know that.

THanks,