• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 397
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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