How to add confirmation window Closed

Question

Hello, 

I used below mentioned macro for locking teachers mark entry file. How to add a confirmation window like "Do you want to lock your data"?

Sub Verified()
ActiveSheet.Unprotect Password:=1357
    Range("D3:F3").Select
    Selection.Locked = True
    Selection.FormulaHidden = False
    Range("C5:F49").Select
    Selection.Locked = True
    Selection.FormulaHidden = False
ActiveSheet.Protect Password:=1357
ActiveWorkbook.Save
MsgBox ("Your data verified and saved successfully")
End Sub

Configuration: Windows 8 / Chrome 28.0.1500.72

ac3mark · Answer

Good Morning,

I hope this give you some direction


x=MsgBox("Locked data?",4,"Please answer")
If x = "Yes" Then
Dosomething
End If 
 

Have Fun!
I'm done with this site. I came here for help, helped while I was waiting, and I have had my hand slapped for walking on toes, but I still get walked on!  Have fun Unlocking Facebook and DL WHATSAPP!

How to add confirmation window

1 response

Similar discussions

Subscribe To Our Newsletter!