View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default How to unprotect a workbook by macro?

for worksheets without a password:

Sub UnlockSheet()
Worksheets('sheetname').Unprotect
End Sub

or if it has password

Sub UnlockSheet()
Worksheet('sheetname').Unprotect password:="password"
End Sub

"FARAZ QURESHI" wrote:

HELP! HELP! HELP!
I have a workbook with its structure locked. How to unprotect a workbook by
macro?