LinkBack URL
About LinkBacks
Caps lock wont matter in code, unless the password is in caps, but it looks the same.
What is erroring the unprotect?
Caps lock wont matter in code, unless the password is in caps, but it looks the same.
What is erroring the unprotect?
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Sub Unprotect()
'stops screen updating
Application.ScreenUpdating = False
'unprotects locked cells
For Each sht In ActiveWorkbook.Sheets
sht.Unprotect Password:="teslinoor"
Next
ActiveWorkbook.Unprotect Password:="teslinoor"
End Sub
"sht.Unprotect Password:="teslinoor" is the error. I have even tried manually unprotecting the file by typing in nthe password from the protect macro, but that has failed as well. Now my file is locked and I unable to unlock it for further editions.
-JT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks