Disable read-only property of a workbook

Hi guys,

I have a macro that I run which captures data. It then opens up another workbook with the intent of writing this information to it. Opening the secondary workbook in my code isn't the problem. The problem is I have the secondary workbook set as read-only (there is a reason for this). I want my macro to temporarily disable the read-only property, write to the file, and then turn the read-only property back on.

Any ideas on how I do this?

Thanks,

Chris

No, I set the read-only property by right clicking on it, selecting general options, and then ticking the 'read-only' box.

I do this because when users open this secondary file I only want them to be able to view the information - I don't want them to have the option of writing to it. The writing of information to this file is to be done purely by the macro I've written in the primary spreadsheet.

Hope that makes sense!

Excellent - sorted!

Thanks very much for your help!

Chris