Macro; need to disable one when another is running

[ed.ayers315]

Hi Folks,

I need to disable or not allow one certian macro from running when another is running.

I reviewed previous posts and found

Application.Enable.Events = False

Unfortunately this disables other item I do need to run Like Spell Check.

When this macro

Sub COMPILE_VESSEL_DATA()

is started

I do not want this change event to run

Private Sub Subject_Title_51C_V1_Change()

Any suggestions

 

[mikerickson]

You could declare a Public variable

Public Abort as Boolean

Sub COMPILE_VESSEL_DATA()
    Abort = True
    
    Rem code

    Abort = False
End Sub

Sub Subject_Title_51C_V1_Change()
    If Abort then Exit Sub

    Rem code
End Sub

 

[ed.ayers315]

mikerickson, thanks for the advice

I did not get that to work so I went with a workaround, not what I wanted but it will do.

Have a great weekend.