Thread: Warning Message
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson Ken Johnson is offline
external usenet poster
 
Posts: 1,073
Default 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