Closing userforms when moving between worksheets

**dudestock** · 07-06-2007, 02:02 AM

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** · 07-06-2007, 03:02 AM

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

Option Explicit

Private Sub Worksheet_Activate()
UserForm1.Show
End Sub

Private Sub Worksheet_Deactivate()
UserForm1.Hide 'or
'Unload UserForm1
End Sub

Closing userforms when moving between worksheets

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Closing userforms when moving between worksheets

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions