View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Sam Wilson Sam Wilson is offline
external usenet poster
 
Posts: 523
Default 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
...