title: Best way to protect Excel VBA code?
body: <p>I've put together a simple Excel database that performs a few macro functions and I need to distribute this database to a few people - but they cannot see how the macro function actually works (stupid rules I have to follow!). What is the best way to achieve this?</p>
  
  <p>I've done a bit of research and I found two ways:</p>
  
  <ul>
  <li><p><strong>Password protect the VBA project</strong>; but this is apparently very easy to break using readily available tools online (it would be in the best interest to the people I'm sending this to find out how the macros and functions work; so I'm almost 100% sure they will try to get into it.. hence a password protection seems inadequate.</p></li>
  <li><p><strong>Move to a fully compiled language like C++</strong>; my skills are very limited to VBA on Excel and Access so this being the ideal solution; isn't a solution for me :(</p></li>
  </ul>
  
  <p>Are there any other ways? I thought of having a 'master excel document' with all the macros in that and then send 'children' databases to the end users and have the 'children' databases connect to the 'master' - is something like this possible? By hosting the master online or even sending the end users the master but making it completely inaccessible unless accessed by the 'children' databases?</p>