Hide Excel 2010 UserForm when sheet behind is clicked 1

[PWD]

Good afternoon, is it possible to 'hide' a UserForm when it loses focus, i.e. when the sheet behind is clicked & regains focus?

BTW this form becomes visible courtesy of

Private Sub Workbook_SheetActivate(ByVal Sh As Object)

It no big deal if it can't, I just fancied adding it in if it could.

Many thanks,
D€$

 

[SkipVought]

hi,

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
    UserForm1.Hide
End Sub

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
    UserForm1.Hide
End Sub

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PWD]

Hi Skip I'll have a look at this tomorrow.

Many thanks,
D€$

 

[PWD]

Or next-week's tomorrow!!

Heck

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
    UserFormExclusions.Hide
End Sub

does the trick. STAR!!!!

Many thanks,
D€$

 

[PWD]

Well bless my soul Skip. That certainly did do the trick! Many apologies for not acknowledging it at the time.

Many thanks,
D€$

 

[SkipVought]

[tt]

May your soul be blessed, not un-irregardless!
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PWD]

Y'all bin listenin' too much ta George W!

Many thanks,
D€$