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
