Previous Topic Next Topic

How to add confirmation window

Closed
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
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

Related:

1 reply

Answer 1 / 1
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
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!
0