View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Is there a SUB like "Sub Worksheet_De-Activate()"?

Hi,

CRayF,

The event you are looking for is the Worksheet_Deactivate event.

If you select 'Worksheet' in the first dropdown box at the top of the
worksheet code module, the second dropdown box will list all available
events.


---
Regards,
Norman



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