leave sheet event

[Aaron]

Hello,

I believe I need to use the deactivate sheet event to run a macro, but don't
know how to code it.

I have a sheet named RateAdjust where we make some adjustments. When I
leave that sheet, I'd like to run my macro RefreshPivots. I'm sure this is
simple. Can someone help. Thank you so much,

[Chris]

1. Go to the IDE.
2. Select the worksheet from "Microsoft Excel Objects".
3. Change the drop-downs in the coding area, located at the top of the IDE,
to "Worksheet" and "Deactivate".

hope that helps.

"Aaron" <[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> I believe I need to use the deactivate sheet event to run a macro, but
> don't
> know how to code it.
>
> I have a sheet named RateAdjust where we make some adjustments. When I
> leave that sheet, I'd like to run my macro RefreshPivots. I'm sure this
> is
> simple. Can someone help. Thank you so much,