Setting Password & WriteResPassword
Kevin H. Stecyk...
Setting Password & WriteResPassword
Once I have opened a workbook that is Password protected and
WriteResPassword protected, how do I then save the workbook with a new
Password and WriteResPassword?
I know to open a workbook it is simply:
Workbooks.Open Filename:="MyBook.xls", Password:="TopSecret1",
WriteResPassword:="TopSecret2"
I thought Workbooks("MyBook.xls").Close would have the same properties.
But it doesn't.
Any guidance is appreciated.
Regards,
Kevin
ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\Junk\DeleteBook.xls", FileFormat _
:=xlNormal, Password:="delete", WriteResPassword:="delete", _
ReadOnlyRecommended:=True, CreateBackup:=False
|