Events, dear boy, events

G

Gromit

Hi

I seem to be having problems with worksheet-level events.

I'm pasting:

Private Sub Worksheet_Deactivate()
MsgBox "Hi!"
End Sub

Into the sheet-level code sheet. The code isn't triggering when I leav
the sheet.

Any setting I might be missing?

Cheers,

Gromi
 
B

Bob Phillips

Did you put it in the correct sheet module?

Application.EnableEvents not disabled anywhere?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top