Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
EnableEvents = False not working ???
Code below is on the sheet where I've put ActiveX combo box named cboOthProv,
for which the linked cell is A1. If I put a stop on the very first line, then step through, at line Range("A1") = "" execution jumps back to the start, as if events had never been disabled. Isn't the change to the combo box through its linked cell an event? And if it is, then why doesn't Application.EnableEvents = False keep it from triggering the combo box change code to begin again? This is seriously sending me around the bend. Any clues/advice are most welcome. Private Sub cboOthProv_Change() Application.EnableEvents = False Set rg = ActiveCell t = Range("A1") Range("A1") = "" Select Case t Case "Hide unselected": HideNoPicks Case "Show unselected": UnhideNoPicks Case "Renewal Changes": BlueNoBlue Case "Hide Accumulators": AccHiding Case "Show all Accums": AccUnhiding End Select rg.Activate Application.EnableEvents = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application.enableevents = false not working in workbook open even | Excel Programming | |||
Application.EnableEvents = False not working | Excel Programming | |||
EnableEvents=False doesn't work? or does it? | Excel Programming | |||
Application.EnableEvents = False not working | Excel Programming | |||
object.EnableEvents = false | Excel Programming |