Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

Protection for Excel macros

Locked

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.

Topic

Clarifications

In reply to Protection for Excel macros

Clarifications

Anyone?…bump…

In reply to Protection for Excel macros

Anyone?…bump…

bump…….

In reply to Protection for Excel macros

bump……………..

Protection of VBA Code

In reply to Protection for Excel macros

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……..

[Author]

Replies