<div>
Thanks for the quick response Shanan212. &nbsp;That worked perfect!
</div>


Thanks for the quick response Shanan212.  That worked perfect!

<div>
<div class="content wysiwyg-content">
I'm hoping to add code to an existing tool that does the following:<br />
<br />
When a user moves from a tab called 'Summary' to any other tab in the workbook, then trigger code. &nbsp;Otherwise, if they move between any other tabs, don't do anything. <br />
<br />
I'm struggling with coming up with the 'event' for changing to a different worksheet.<br />
<br />
Any help is greatly appreciated!
</div>
</div>


I'm hoping to add code to an existing tool that does the following:

When a user moves from a tab called 'Summary' to any other tab in the workbook, then trigger code.  Otherwise, if they move between any other tabs, don't do anything. 

I'm struggling with coming up with the 'event' for changing to a different worksheet.

Any help is greatly appreciated!

Excel VB Worksheet Change Event Triggeer

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.