DeActivate event is triggered when you select another worksheet..

Private Sub Worksheet_Deactivate()
MsgBox "ok"
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"jswalsh33" wrote:

Is there a way to run a particular macro when focus is change from a
particular worksheet to any other worksheet by selecting another worksheet?

Thanks for your help.

Jim Walsh