Hi there,

I have a workbook on a shared server. Multiple users will post results to this shared workbook from a local workbook on their own systems. So Excel will need write access to the workbook in order to do this for each of these users. There is no reason for the users to manually edit the workbook themselves, although they will want to read through it, so write access is only required when logging things to this shared workbook.

I want to minimise read-only errors associated with this, so my question is... is it possible to set things so that the user themselves cannot open the file themselves on Windows Explorer with write access, and only open it as read-only.

I'm currently working on the assumption that the users will have read and write access to that file, and I am assuming Excel's rights are dictated by that of the user, so what I'd do is get Excel to set the attributes of the file to read and write when logging stuff, then after logging it and closing the workbook, setting the attributes back to read only. But then the user could get around this by going to the file properties and changing the settings. Is there any way to keep the user rights as read-only but provide the Excel macro logging stuff in the local users' workbooks with read and write access?

Many thanks,