Remove file ownership properties when saving

[liampog]

Hi

I work at a company with a "Shared" drive, however, any files saved on to this drive by a user are owned by that user and it means nobody else (with their own respective logins) can then open the file in NON Read-Only mode. It always opens the file in Read Only.

Is there any way within VBA that the file can be saved but with no ownership properties?

Thanks
Liam

 

[James006]

Hi,

You should take a look at : ActiveWorkbook.BuiltinDocumentProperties

Hope this will help