+ Reply to Thread
Results 1 to 6 of 6

Alternative protect VBA in excel

  1. #1
    Registered User
    Join Date
    09-10-2016
    Location
    Iran
    MS-Off Ver
    2010
    Posts
    12

    Alternative protect VBA in excel

    Hello,
    except Tools - > Protection , is there strong way to protect VBA?
    Thanks

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,930

    Re: Alternative protect VBA in excel

    You can password protect your VBA. In the VB Editor select "Tools / VBAProject Properties / Protection".

    However, even this is not VERY secure. If someone wants to get at your code and has a little know-how then they could get at it with very little effort no matter what security measures you put in place.

    BSB

  3. #3
    Registered User
    Join Date
    09-10-2016
    Location
    Iran
    MS-Off Ver
    2010
    Posts
    12

    Re: Alternative protect VBA in excel

    Quote Originally Posted by BadlySpelledBuoy View Post
    You can password protect your VBA. In the VB Editor select "Tools / VBAProject Properties / Protection".

    However, even this is not VERY secure. If someone wants to get at your code and has a little know-how then they could get at it with very little effort no matter what security measures you put in place.

    BSB
    Does not have an alternative way to more secure VBA?

  4. #4
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Alternative protect VBA in excel

    No, Excel is not a secure platform.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  5. #5
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Alternative protect VBA in excel

    Hi,

    There are third party tools to make it more secure, but nothing built-in to Office.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  6. #6
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Alternative protect VBA in excel

    Everything can be hacked, it's just a matter of willingness, time and money...
    and of course the value of your code

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. More Powerful Alternative to Excel
    By protcg in forum Excel General
    Replies: 1
    Last Post: 07-27-2017, 11:56 AM
  2. Excel 2013 - Protect Range of Cells without using Protect Sheet Button
    By caf20012 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-23-2014, 04:50 AM
  3. Alternative to Excel VBA Editor ?
    By Entellex in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2013, 12:31 AM
  4. [SOLVED] Countifs alternative for Excel 2003
    By Jigz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-02-2012, 01:12 PM
  5. Excel 2007 : Alternative for SUMIFS in excel 2003
    By ahmedmido in forum Excel General
    Replies: 4
    Last Post: 12-11-2009, 09:58 AM
  6. Replies: 1
    Last Post: 03-19-2009, 03:20 AM
  7. [SOLVED] Excel If function alternative
    By saborbas in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-24-2005, 08:07 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1