Solved

Hide the code to the End User in VBA through Excel

Posted on 2011-02-22
2
233 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
[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
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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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.

Question has a verified solution.

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

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…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

749 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