Warning before running a macro

Question

Hi Everyone,  would appreciate some help.  I have a command button to run a macro, is it possible to create a warning before running the macro? Like "Are you sure you want to run Macro". 

Thanks for your continuous suport

Answer 1

You can build the prompt into the macro itself:

Sub MyMacro()

    If MsgBox("Are you sure that you want to run a macro?", _

            vbYesNo + vbQuestion) = vbNo Then

        Exit Sub

    End If

    ' Your code goes here

    ...

End Sub

Answer 2

I missed that this post is about Excel. I'm looking for this functionality in Access. I thought I found something on msgbox there, but couldn't make it work.

Answer 3

If the macro is stored in the active workbook:

Press Alt+F8 to display the Macro dialog.

Select the macro in the list.

Click Edit.

This won't work for macros in your personal macro workbook Personal.xls(b). To edit those:

Press Alt+F11 to activate the Visual Basic Editor.

Expand VBAProject (PERSONAL.XLSB) (the B is only present if you're using Excel 2007 or later).

Expand Modules.

Double-click one of the modules under Modules to view and edit the code in that module.

Answer 4

I have built a lot of macros using the user interface but can't figure out how to get to the code behind it to add this to one of my macros.

Answer 5

Thank You it worked briliantly.