| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Sheet #'s, but leave cell reference | Excel Discussion (Misc queries) | |||
| Excel sheet: scroll down, but leave first lines visible | New Users to Excel | |||
| How to leave the lines on my exel work sheet | Excel Worksheet Functions | |||
| Transpose from one sheet to the next and leave out blank cells | Excel Discussion (Misc queries) | |||
| Start a sheet event when i leave a sheet | Excel Programming | |||
Linear Mode
