I have an Excel 2010 add-in resident on a server. The majority of users will only require read access to run VBA code to create a user form and to save the contents to their own specific workbook. A limited number of users will need to update lists held within the add-in.
Is this achievable by granting one set of users read only access and the others read / write access. These last (read / write) users will rarely, if ever, need to write to the add-in at the same time