"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