Software

Ask something
Question Locked

Protection for Excel macros

0 helpful
4 replies

by rizwan_emailme

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a visual basic project written on the VB environment found in MS Excel (Basically an Excel macro). I want to be able to protect this code from prying eyes. I have tried using the VB password protection and 'locked the project' from viewing. But as I understand it, this is a very weak protection, and stuff can be downloaded off the web that can easily break it. I am looking for alternative methods to protect my file.

My intention is to distribute this MS Excel file within my company. I want the worksheets to be visible for use, but the source code I want protected at all cost.

One possibility I think is to build an exe file from this MS Excel file. But I am not sure how this works or how to do it. Any advice is welcome. Thanks.

4 replies

by suhailmsq

Hello,
You Can Protect your VBA code, Go to VBA code right click on VBA Project then select VBA Project Properties--then click on Protection tab there u can give Password for Protection. clik ok, save the file, Try it It should work......... thanku..... u cannot make exe file for MS-excel but u can make like exe file, just write the code in fiel Opent event ---- application.visible=False-- it will be good for form only........

This discussion is closed to new replies.