XL2002 - trigger sheet event BEFORE deactivating
Hi Trevor,
What you are looking for is a BeforeDeactivate event with a Cancel, and
there isn't one. Workaround is to reactivate the sheet if necessary
Private Sub Worksheet_Deactivate()
If Len(Range("A1")) = 0 Then ' empty cell A1
On Error GoTo errH:
' if necessary disable events
Application.EnableEvents = False
Me.Activate
Application.Goto Range("A1"), True
MsgBox "Complete cell A1"
End If
errH:
Application.EnableEvents = True
End Sub
Regards,
Peter T
"Trevor Williams" wrote in
message ...
Hi All
I want to inform a user of incomplete cells if they attempt to move to a
different worksheet.
The Worksheet_Deactivate event takes the focus away from the current sheet
before running the code. Is there another event I can use that runs
before
displaying the next sheet?
Thanks in advance
Trevor Williams
|