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,
|