Solved

Hide the code to the End User in VBA through Excel

Posted on 2011-02-22
2
230 Views
Last Modified: 2012-05-11
I want the end user not to view my code for the VBA application that i have created in Excel.

He should not be able to view the code either through Developers tab as well

Please let me know the way it can be acheived.
0
Comment
Question by:srikanthv2322
2 Comments
 
LVL 24

Accepted Solution

by:
broomee9 earned 500 total points
ID: 34951961
You can password protect your code so that it can't be seen.

Go to the VBE by pressing Alt + F11, then right click on your module and select VBAProject Properties.  Then click the Protection tab and click the "Lock project for viewing" checkbox.  Enter a password and click OK.
0
 
LVL 24

Expert Comment

by:jimyX
ID: 34951969
Did you try:
Tools>VBA Project Properties>Protection
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to read BOM (Byte Order Mark) from csv file. 4 37
File not loading into PowerPivot 4 9
macro for closing opened workbook 6 21
Dynamic Filter ? 4 21
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

867 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

16 Experts available now in Live!

Get 1:1 Help Now