Macro

[Guest]

In your macro, say:



Dim Msg, Style, Answer As String
Msg = "Do you really wanna do that?"
Style = vbOKCancel + vbDefaultButton2

Reponse = MsgBox(Msg, Style)

If Reponse = vbOK Then

'Your previous code here

End If



Jerome

-----Original Message-----
I have created a Macro that resets my spread sheet to a default setting.
A command Button runs this macro and when I click the

button the sheet resets to the original setting.
Question.... is there a way that when I click this reset
button I clould get a massage that asks if I really want
to run this macro. I want this feature to keep me from
accidently resetting the spread sheet.

 

[Guest]

Of course you translated 'Reponse' into 'Answer' in the
lines lower...