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