leave sheet event
 

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,

leave sheet event
 

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" wrote in message
...
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,