If the two worksheets are in separate workbooks, you may want to use the
workbook event:
Private Sub Workbook_Deactivate()

(maybe both????)

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

--

Dave Peterson