Solved

Excel 2010 Add-in - Read / Write

Posted on 2013-05-15
1
330 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
1 Comment
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

I found this questions asking how to do this in many different forums, so I will describe here how to implement a solution using PHP and AJAX. The logical flow for the problem should be: Write an event handler for the first drop down box to get …
Styling your websites can become very complex. Here I'll show how SASS can help you better organize, maintain and reuse your CSS code.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

744 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now