View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chris Chris is offline
external usenet poster
 
Posts: 4
Default 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,