Solved

EXCEL 2010

Posted on 2014-11-18
3
87 Views
Last Modified: 2014-12-15
Hi Experts, how can I make excel 2010 file protected :

1. end user cannot modify VBA
2. end user cannot modify add-in paths in options
3. end user cannot modify any options that I set

Thanks.
0
Comment
Question by:fpoyavo
3 Comments
 
LVL 25

Accepted Solution

by:
ProfessorJimJam earned 500 total points
ID: 40450151
i mean there are easy ways to put a password protection, but they are always frangible. if users wants to get into that.

there are some websites that offer protection that are good but not best. like http://www.lockxls.com/product.asp  which is sell commerical license protecting the workbook vba interface.

however, if you intend to make it bullet proof, then you could create a COMM add-in compiling your add-ins in DLL files.
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 40499965
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

785 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