Question

  • Creator
    Topic
  • #2226880

    Protection for Excel macros

    Locked

    by rizwan_emailme ·

    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.

All Answers

  • Author
    Replies
    • #2479242

      Clarifications

      by rizwan_emailme ·

      In reply to Protection for Excel macros

      Clarifications

    • #2472157

      Anyone?…bump…

      by rizwan_emailme ·

      In reply to Protection for Excel macros

      Anyone?…bump…

    • #2469853

      bump…….

      by rizwan_emailme ·

      In reply to Protection for Excel macros

      bump……………..

    • #2551389

      Protection of VBA Code

      by suhailmsq ·

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

Viewing 3 reply threads