| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a SUB like "Sub Worksheet_De-Activate()"?
Thanks Jim,
This has helped. "Jim Thomlinson" wrote: All of the available events are listed in the drop down boxes just above the code window. The events exits in sheets or in the ThisWorkBook object. Just above the upper left of the code window change the drop down from General to (whatever is listed, worksheet, button, ...). When you do this a procedure will be dropped into the code window (you can just delete it if it is not the event you want). The Drop down in the upper right above the code window will list all of the events that the item you have chosen can respond to. Select the one you want and you are good to go... -- HTH... Jim Thomlinson "CRayF" wrote: Private Sub Worksheet_SelectionChange() Private Sub Worksheet_Activate() Is there actions I can take when the current Workshhet is being "left" as opposed to Activate? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Activate "Show all" in a Protected Shared Workbook | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| How do I activate the "greyed out" hyperlink function | Excel Discussion (Misc queries) | |||
| Checking before opening "activate:newwindow" to see if already opened | Excel Programming | |||
| selection.find shortening the procedure by skipping the "activate" part | Excel Programming | |||
Hybrid Mode
