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