Excel VBA write protected

[gustaf111]

Hello again,

I have another problem also ...

I have an excel file that is write protected.

1) I would like to open the file protected and with help of a button be able to save the changed of the contect and with the file still write protected so I can not use the save button within excel.

2) I would like also to change the name of the file with the file still writeprotected.

Please help! Gustaf

 

[UnsolvedCoding]

it is my understanding that if any file is write protected it cannot be updated. If you can you would need to write code that would unprotect, make the changes and then re-protect.

 

[gustaf111]

Yes, that is what I want to do