ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   UserForm (https://www.excelbanter.com/excel-programming/334552-userform.html)

Steve

UserForm
 
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,




All times are GMT +1. The time now is 11:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com