Copied file does not copy as Read Only?

[advox1]

Hi,

I have some code which creates a new folder and copies a workbook into it. The original copy of the workbook is Read Only, defined by the properties and not passwords.

The problem is that when I copy the workbook to the folder it looses the Read Only protection. How can I ensure that this does not happen or change the file back to read only once it has copied?

Thanks

Jo

 

[BrainB]

When you *SaveAs* a file you can set the property ReadOnlyRecommended = True. *The user then gets the option* to open the file as read only or not.

If you do not want to allow changes to the file you can intercept and disable the Save in the ThisWorkbook Before_Save event, (Cancel = True) and likewise the Before_Close event (... Close .... SaveChanges=False)




Regards
BrianB
Use CupOfCoffee to speed up all windows applications
================================

 

[advox1]

Hi

Thanks for your help but I have decided to protect the sheets and unprotect them when required.

Jo