Run Macro Confirmation

Posted by Michael Adams on July 27, 2001 8:45 AM

I have a button that runs a macro, is there any way
to have a pop-up message saying, "Are you sure you
want to run the macro?" when I click the button?

Posted by faster on July 27, 2001 8:54 AM

'place this before you code
if msgbox("Run Macro?",vbyesno)=vbno then
exit sub
end if

Posted by Barrie Davidson on July 27, 2001 9:02 AM

Use:
If MsgBox("Are you sure you want to run the macro?", vbYesNo) = vbNo Then
Exit Sub
Else
End If

Barrie