Link to home
Start Free TrialLog in
Avatar of rdevriend
rdevriend

asked on

Hide VBA code in Excell

Is it possible to hide VBA code that I have created for an Excell spread sheet.
I don't want that the user/client look into the code.

Thanks in advance
Rene
Avatar of vboukhar
vboukhar

Yes, you can lock your project - in VBA editor press Service-Properties of ...xls, choose tab Protection, check Lock project and type in your password. (menu items names could be different - I use non-English version of Excel).
Hope it helps
ASKER CERTIFIED SOLUTION
Avatar of calacuccia
calacuccia
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You can also change the color of the code. but I would prefer  the previous 2 methods.
Avatar of rdevriend

ASKER

Thanks calacuccia, it works!
I am just a beginner in VBA, so I did not knew that it was so simple.

Sorry, vboukhar, you answer was the same, but calacuccia's was a slightly bit better explained.

(By the way, I accepted this answer already a few days ago, but appearently it did not came through, so it is here again).