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)
|