Remove file ownership properties when saving

liampog

Active Member
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

Well-known Member
Hi,

You should take a look at : ActiveWorkbook.BuiltinDocumentProperties

Hope this will help
 

Some videos you may like

This Week's Hot Topics

Top