Solved: unload userform before worksheet deactivate

[av8tordude]

I have a userform that I would like to be unloaded before selecting a different worksheet. I know I can just close the userform, but as a backup to forgeting to close the userform, I would like the userform to close automatically. Any suggestions? Thanks.

[anandbohra]

by the way when u show a userform how can a user select different worksheet?
he has to compulsorily close userform for returning to excel


of something else in your mind type this code in this workbook code

[VBA]Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
unload UserForm1
End Sub
[/VBA]

[mdmackillop]

Anandbohra
If the Userform is opened non-modally, the user can use the spreadsheets etc. as normal. This is done using
[vba]
Userform1.Show False
[/vba]

[anandbohra]

Anandbohra
If the Userform is opened non-modally, the user can use the spreadsheets etc. as normal. This is done using
[vba]
Userform1.Show False
[/vba]

Thanks mdmackillop
It something new for me

btw av8tordude I hope your query is solved as my code unload non-modally opened user form on sheet change

[av8tordude]

Thank you both