Microsoft Office Forums - View Single Post - [Solved] Macros from this Forum will not run.

jeffreybrown · 10-02-2018, 03:58 PM

Not sure if it will help you or not, but I used the code from post #3 and it runs fine.

Also, the msgbox you added will never run as you have placed it directly after Exit Sub.

This

Code:

MsgBox "Yes, it ran." 'Added.
Exit Sub
End Sub

Not This

Code:

Exit Sub
MsgBox "Yes, it ran." 'Added.
End Sub

But even with this, not sure why you even need Exit Sub as there is nothing left to do or skip.