Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The code below calls a userform any time a cell is selected within that
range and it works fine, but, the routine which is triggered by a button on the userform also selects a cell within that range causing the userform to reappear. Is there any way to suspend that code while the macro runs its course? Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Not Application.Intersect(Target, Range("A5:A200")) Is Nothing Then Path_Of_Action.Show End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
suspend auto increment | Excel Discussion (Misc queries) | |||
Suspend Execution | Excel Programming | |||
Suspend macro while others are running | Excel Programming | |||
Suspend code | Excel Programming | |||
Screen suspend | Excel Programming |