Bounce a note when you press a macro button

New Contributor


I created a macro button that works fine, but since after running a macro there is no possibility to use CTRL+Z, I'm looking for an option to bounce a note when the macro button is pressed, just before the macro goes into action.

3 Replies



I take it you want a popup confirmation message?


Sub temp()
     Const msgWarning = "Actions performed by macro cannot be undone. Continue?"
     If MsgBox(msgWarning, vbYesNo + vbExclamation) = vbNo Then
          Exit Sub
     End If
End Sub



Yes thank you!

Works great

You are welcome.