How to add confirmation window

jinoob Posts 13 Registration date Monday February 18, 2013 Status Member Last seen October 1, 2013 - Jul 26, 2013 at 08:04 AM
 Blocked Profile - Jul 26, 2013 at 09:40 AM

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
Selection.Locked = True
Selection.FormulaHidden = False
Selection.Locked = True
Selection.FormulaHidden = False
ActiveSheet.Protect Password:=1357
MsgBox ("Your data verified and saved successfully")
End Sub

1 reply

Blocked Profile
Jul 26, 2013 at 09:40 AM
Good Morning,

I hope this give you some direction

x=MsgBox("Locked data?",4,"Please answer")
If x = "Yes" Then
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!