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