Is there a SUB like "Sub Worksheet_De-Activate()"?
 

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?

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?

Is there a SUB like "Sub Worksheet_De-Activate()"?
 

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?

Is there a SUB like "Sub Worksheet_De-Activate()"?
 

Hi CRayF,

Additionally, you might care to visit Chip Pearson's page on event
procedures at:

http://www.cpearson.com/excel/events.htm


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

Is there a SUB like "Sub Worksheet_De-Activate()"?
 

Private Sub Worksheet_Deactivate()


"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?

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?