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

Just include code in your macro that includes an OK/Cancel Box -- and have OK
be continue running, have cancel stop the macro there.

"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

Option Explicit
sub yourmacro()

resp = msgbox(Prompt:="wanna run this?", buttons:=vbyesno)

if resp = vbno then exit sub

....
end sub



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

--

Dave Peterson

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

Option Explicit
sub yourmacro()

dim resp as long '<-- I forgot this!

resp = msgbox(Prompt:="wanna run this?", buttons:=vbyesno)

if resp = vbno then exit sub

....
end sub

Dave Peterson wrote:

Option Explicit
sub yourmacro()

resp = msgbox(Prompt:="wanna run this?", buttons:=vbyesno)

if resp = vbno then exit sub

....
end sub

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

--

Dave Peterson

--

Dave Peterson