Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 .... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop through sheets & filter main sheet using sheet name | Excel Programming | |||
Deactivate workbook commandbar for one sheet? | Excel Programming | |||
Trouble with Sheet Deactivate macro | Excel Programming | |||
Deactivate sheet | Excel Programming | |||
Sort sheet on sheet's Deactivate event | Excel Programming |