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

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