View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Edmund Edmund is offline
external usenet poster
 
Posts: 62
Default 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