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

[Kevin H. Stecyk]

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

[Dubrock]

Bit of an old thread, but my question is pretty much related.

I managed to add password protection to my excel file with VBA, using the following code:

Please Login or Register  to view this content.

How to remove the passwords with VBA?
I do still have the passwords and can open my file, but somehow using ThisWorkbook.SaveAs password:="", writeResPassword:="" doesn't work.

[AliGW]

Administrative Note:

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread