|
Full Excel VBA Macros
|
|
| Prompt to Confirm Macro Run | |
| Sub Confirm_Macro_Run() | |
| Msg = "Do you really want to run this macro?" | |
| Ans = Msgbox(Msg, vbQuestion + vbYesNo, "Are you sure???") | |
| Select Case Ans | |
| Case vbYes 'user selects Yes | |
| 'put macro code to be run here | |
| Case vbNo 'user selects No | |
| Exit Sub 'exit the macro and do nothing | |
| End Select | |
| End Sub | |