View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Edmund
 
Posts: n/a
Default Unlock for Viewing

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
should I do?

Many thanks

--
Edmund
(Using Excel XP)