Warning Message
tom wrote:
Prior to executing a Macro in a workbook, I would like a Warning message to
pop-up asking the user to verify they are wanting to run this macro.
TFTH,
Tom
Hi Tom,
If you are able to edit each macro's code then you could have each
macro start off with these three lines...
Dim msgCheck As VbMsgBoxResult
msgCheck = MsgBox("Are you sure you want to blah blah?", vbYesNo)
If msgCheck = vbNo Then Exit Sub
Edit "blah blah" to something applicable to the macro's function.
Ken Johnson
|