Tuesday, November 14, 2017

Personal Toolkit

I work with a significant number of Excel Documents.  Oftentimes I need to be able to view and understand these documents quickly in order to produce results.



I created for myself a small tool set which allows me to do the following things (Please note, they have only been used and tested on Excel 2010):

  • Crack Worksheet Passwords
  • Crack VBA Passwords 
  • Export all of my Modules to .bas files
  • Make an Excel File's VBA project Unviewable
  • Use the "DPx Trick"
  • Make all VBA Modules Hidden
Now, I do want to put a disclaimer: Although most of code is my own, there are pieces of code that I have found in other places. I have just combined it to be useful for me--and hopefully useful to you.  Also, for those of you looking for an excellent, solid, and very secure way to hide your VBA code from others, I recommend looking elsewhere. This could, however, hide code if you wanted to protect it from most people, and you're not too worried if somebody with some significant knowledge can break into it.

Enjoy!

Download Here!
http://www.hidemyvba.com/HideMyVBA.xlsb

Click To Download

About This Blog

Thank you for visiting my blog!

Let's make this brief and easy!  I have used Excel for many things--especially VBA coding. I have been employed to create spreadsheets and powerful Excel tools, I have learned many things on my own for fun, and I use Excel to manage things like my budget and more.

I decided that it might be of help to others if I made some of my tricks and tips public. I do not anticipate posting a significant amount of posts, but when I occasionally find something particularly useful then you will see it!

For the most part, a diligent Excel user can find out how to do just about anything they want on the web. In fact, I often find little tidbits of code on the internet that I use!

Please enjoy!

VBA Add an animated Notification Box to your Excel Program

For those of us who create programs and add-ins in Excel, we are very, very familiar with the message box.  The message box gives us the opp...