PDA

View Full Version : Make file read/write



lifeson
04-04-2008, 05:51 AM
Hi All,
I have nearly finished my project which I would not have been able to do without the help of members on here - XLD I'm looking at you!
I am at the point of sending it out for testing and review but have come across a small problem
The file will be distributed on CD and when the users copy it to their machines it becomes Read Only.
Their system will not allow them to change the properties of the file, therfore is there any code that when run will when opening the workbook and will:

check if file is read only
If file is 'read only' then make it 'read write'
If file is already 'read write' then do nothing

Simon Lloyd
04-04-2008, 10:36 AM
Usually after you have the file off CD you merely need to SaveAs a different name and it usually saves as full access!, so in your workbooks open you could save the file as a new name and set whatever access you want then Kill the original workbook.