• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 393
  • Last Modified:

Excel 2010 Add-in - Read / Write

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
0
NormanMitchell
Asked:
NormanMitchell
1 Solution
 
Rory ArchibaldCommented:
Personally I would recommend you keep the data separate from the code in another file (workbook/add-in/database as appropriate).
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now