Unlocking for viewing (in VBE)
Assuming all my passwords are "abc"
To unprotect my active sheet, I do€¦€¦
ActiveSheet.Unprotect €śabc€ť
To unprotect my write protected workbook, I do€¦€¦
Workbooks.Open Filename:=TargetPathAndName, WriteResPassword:= €śabc€ť
But to €śunlock for viewing€ť in VBE, my module1 under Project Name Book, what
the code like?
Many thanks
|