Macros from this Forum will not run.

[jeffreybrown]

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

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

Not This

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.