Sheet Deactivate Loop
And don't forget to set it back to True at the end of your code...
Application.EnableEvents = True
--
Rick (MVP - Excel)
"Sam Wilson" wrote in message
...
use
application.enableevents = false
"Jason Morin" wrote:
I run a series of checks on a worksheet (called "Input") before the user
can
click on another sheet called "Output". If Input check outs, I want to
activate the Output sheet and exit the sub. However, this seems to run
the
deactivate event for Input again and the macro loops for a while. Any
suggestions? Thanks -Jason
Sub Worksheet_Deactivate()
...
If iCounter = 0 Then
Sheets("Output").Activate
Exit Sub
End If
...
|