Sheet Deactivate Loop
 

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
....

Sheet Deactivate Loop
 

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
...

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
...