Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Excel 2010 Add-in - Read / Write

Posted on 2013-05-15
1
Medium Priority
?
387 Views
Last Modified: 2013-05-19
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
Comment
Question by:NormanMitchell
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 1000 total points
ID: 39168437
Personally I would recommend you keep the data separate from the code in another file (workbook/add-in/database as appropriate).
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question