Closing userforms when moving between worksheets

[dudestock]

Is there a way to close a userform when a user moves out of the active worksheet. I have a workbook with 3 worksheets. On each sheet is a command that opens a modeless userform.

I would like to know if there is a way to deactivate the modeless userform is the user selects another worksheet without closing the userform first.

Regards.

[royUK]

Use the Worksheet_Activate & Deactivate events.

http://www.excel-it.com/Forum/viewtopic.php?t=11

This code will load UserForm1 as the sheet is activated, and hide or unload it when the sheet is deactivated

Please Login or Register  to view this content.