is there a before_worksheet_deactive sub
 

basically what the title says there is a worksheet deactivate sub but i
there a before worksheet deactivate sub or is it just as simple a
typing before infront thank

--
short_n_curl
-----------------------------------------------------------------------
short_n_curly's Profile: http://www.excelforum.com/member.php...fo&userid=2157
View this thread: http://www.excelforum.com/showthread.php?threadid=38533

is there a before_worksheet_deactive sub
 

If it's not in those dropdowns above the code window, it doesn't exist.

(Just because you can type it, doesn't mean that excel will recognize it as an
event.)

===
There are two dropdowns at the top of the codewindow.

Change the left hand side to Worksheet
and you'll see all the events that belong to the worksheet in the righthand side
dropdown.

You can read more about events at:
Chip Pearson's site:
http://www.cpearson.com/excel/events.htm

David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/event.htm

short_n_curly wrote:

basically what the title says there is a worksheet deactivate sub but is
there a before worksheet deactivate sub or is it just as simple as
typing before infront thanks

--
short_n_curly
------------------------------------------------------------------------
short_n_curly's Profile: http://www.excelforum.com/member.php...o&userid=21576
View this thread: http://www.excelforum.com/showthread...hreadid=385334

--

Dave Peterson

is there a before_worksheet_deactive sub
 

"short_n_curly"
wrote in message
news:short_n_curly.1rtcqg_1120763181.0078@excelfor um-nospam.com...

basically what the title says there is a worksheet deactivate sub but is
there a before worksheet deactivate sub or is it just as simple as
typing before infront thanks


Hi Short_n_curly,

What is it that you are trying to do?

In a new workbook, copy the following into the module behind sheet1.

Private Sub Worksheet_Deactivate()
Range("A1").Value = _
"This was written before I left Sheet1!"
End Sub

Then (with Sheet1 active) select another sheet., return to Sheet, look at
A1.

Does that help?

---
Regards,
Norman