Free Download Excel Vba Projects With Source Code

By default, Microsoft Excel offers VBA project password protection as a way to protect VBA code. This method of VBA code protection is weak and can be easily cracked. The DoneEx XCell Compiler provides a much better and much stronger solution to protect your VBA code from being stolen.

The fact that VBA code is embedded in the Excel workbook itself makes it a difficult task to get it under source control. Many users export/import their modules manually or halfway automatically (see also How to use Git hooks to version-control your Excel VBA code ) and track the exported text file with a version control system like Git. It is for a small, or personal, Auto Repair type business. It should give you practice in learning/use of Invoicing, and installing on the desktop, and programming in vba and MS-Access. Note that the free MS-Access Runtime is with the download. You need MS-Access if you want to work with the program code (part of Office 365). Add Serial Numbers. Sub AddSerialNumbers Dim i As Integer On Error GoTo Last i =.

You can apply strong VBA code protection to the Excel workbook macros by following these easy steps:

1. Open the XCell Compiler compilation form by clicking on the “Compile” item in the DoneEx Excel ribbon menu. Adobe photoshop liquify tool download.

2. Enable the Protect VBA code option.

This should cause the “VBA Protection Options” menu to pop up.

3. Enable “Obfuscation” and “Literal Removing” options in the “VBA Protection Options” window and then click the “OK” button.

You can also just enable the “Unviewable VBA code” option to select both the “Obfuscation” and the “Literal Removing” options at the same time.

4.Compile your workbook by clicking on the “Compile” button on XCell Compiler compilation form.

Once compilation is successful, you should see this window:

Now your VBA macros are strongly protected, and your Excel formulas are protected with the best possible protection thanks to DoneEx XCell Compiler!

How VBA code protection works

To provide the strongest and most reliable VBA code copy protection, DoneEx XCell Compiler uses 2 different approaches which are combined into one solution when you select all of the options of “VBA Protection”.

Unviewable VBA project and VBA source code.

The “Unviewable VBA project” option locks access to the VBA macros, makes the VBA project unviewable, and disables VBA debug mode.
After applying this option, the VBA project and macros will be unviewable and unavailable in the protected workbook.

Anybody who tries to see your VBA Project or Visual Basic code will only see this message.

Any attempt to trace your macro code will fail because VBA debug mode will be disabled.

VBA source code modification.

Two options—the “Code obfuscation” option and the “Literals removing” option—modify the Visual Basic code in a way that keeps the code functional but makes it scrambled and incomprehensible.

After applying the “Literals removing” option, the modified Visual Basic macros become tied to the XCell Compiler run-time library and will only be functional in the protected workbook.

After applying all 3 options simultaneously you will get the strongest VBA source code protection available, which has the following advantages:

The VBA code is unviewable and inaccessible from the Excel VBA project.
The VBA debug mode is disabled, so it is impossible to trace the Visual Basic code.
All comments and empty lines are removed from the macros.
The macors with removed literals will not work outside of the protected spreadsheet.
The VBA soruce code is modified in such a way so that it is incomprehensible and unrecoverable.

Below you can see an example of Visual Basic code transformation after applying both of the code modification options.

The original VBA source code before applying ‘Protect VBA code’ option in XCell Compiler:

After applying both code modification options—the ‘Code obfuscation’ option and the ‘Literals removing’ option—the protect Excel VBA code transforms into the code displayed in this screenshot:

In case if you consider the VBA protection approach based on obfuscation is not secure enough then you need to take a look at DoneEx VbaCompiler for Excel which provides the absolute, bulletproof Excel VBA protection of your VBA code as in workbook as in Excel Add-Ins. The VBA Compiler converts the Excel VBA code into native Windows DLL and provides additional options as VBA code copy protection with registration/activation key.

In this article, I am going to show you some of the most amazing VBA Excel codes that you can use to optimize your work. VBA is a programming language, which can be used to extend the capabilities of MS Excel and other MS Office applications. It is extremely helpful for MS Excel users, because it can be used to automate your work and significantly improve your efficiency. This article will introduce you to VBA and show you some of the most useful, ready to use VBA codes out there. You can use these macro examples to create your own scripts that fit your own needs.

You do not need programming experience to take advantage of the information in this article, but you are expected to have basic knowledge of Excel. If you are a beginner user, I would recommend you to read the article 20 Excel Formulas You Should Start Using Now to learn more about Excel’s core functionalities.

I have prepared for you a number of ready to use VBA Excel Macro examples with great functionality that you can use to optimize your work. In order to use them, you need to “install” them in your Excel file. The next paragraph deals with Excel macro installation. Skip this part if you are already familiar with this.

How to install a macro

In Excel, press the key combination alt + F11. This will take you to the VBA editor in MS Excel. Then, right-click on the Microsoft Excel Objects folder on the left and select Insert => Module. This is the place where the macros are stored. To make use of the macro, you need to save the Excel document as macro-enabled. From the tab file => save as, choose save as macro-enabled workbook (the .xlsm extension) Now, it’s time to write your first macro!

1. Copy data from one file to another.

Very useful macro, as it shows how to copy a range of data from inside vba and how to create and name a new workbook. You can easily upgrade it to fit your own requirements:

2. Show hidden rows

Occasionally, large Excel files contain hidden lines for better clarity. Here’s a macro that will unhide all rows from an active worksheet:

3. Delete empty rows and columns

Blank rows in Excel are a problem with data processing. Here is how to get rid of them:

4. Find a blank cell

5. Replace empty cells with a value.

As previously mentioned, blank cells interfere with data processing and the creation of pivot tables. Here is a code which replaces all blank cells with 0. This macro has a very large application because you can use it to find and replace N/A results, as well as other characters such as dots, commas or duplicate values:

6. Sort numbers

The following macro sorts in ascending order all numbers from the active cell’s column. Just double click any cell from a column you would like to sort.NB: You need to put the code in Sheet 1 and not in a module to work:

7. Remove empty spaces

Occasionally, data in the workbook contains additional spaces (spaces) that can interfere with data analysis and to corrupt of formulas. Here’s a macro that will remove all the spaces from a preselected range of cells:

8. Highlight dublicated values

Sometimes there are duplicate values in the several columns we would like to illuminate. Here’s a macro that does just that:

9. Highlight top ten values

This code will highlight the top ten values from a selection of cells:

You can easily tweak the code to highlight different number of values.

10. Highlight greater than values

When you run this code, a window will prompt. It will ask you the value you want to compare the cells you have selected.

You can tweak this code to highlight lower values as well.

Excel Vba Examples Free Download

11. Highlight cells with comments

A simple macro that highlights all the cells that contain comments:

12. Highlight Cells with Misspelled words

This is extremely useful when you work with functions that take strings, however, someone entered the string with a mistake and your formulas are not working. Here is how to fix this issue:

13. Create a pivot table

Here is how to create a pivot table from MS Excel (2007 version). Especially useful, when you are making a custom report every day. You can optimize the pivot table creation in the following way:

14. Attach active workbook in an Email

My favorite VBA code. It lets you attach and send the file you’re working on with a predefined email address, message title, and message body! You first need to set reference to Microsoft Outlook (in your VBA editior, click on tools => references and choose Microsoft Outlook).

15. Send all Excel charts to a PowerPoint presentation

A very handy macro that lets you add all your Excel charts in your Powerpoint presentation just with a single click:

16. Send Excel table in MS Word

Excel tables are usually put inside text documents. Here is an automated way of exporting your Excel table to MS Word:

17. Extract a specific word from a cell

We can use formulas if we want to extract certain number of symbols. But what if we want to extract only the second word from a sentence or a range of words in a cell? To do this, we can create a custom Excel function with VBA. This is one of the most iportant VBA functionalities, because it lets you create your own functions that are non-existent in MS Excel. Let’s go on and create two functions: findword() and findwordrev(). Here’s the vba code for this:

Very nice, we have created two cstom Excel functions. Now, try to use them in Excel. The function = FindWordRev (A1,1) takes the last word from cell A1. The function = FindWord (A1,3) takes the third word from cell A1, etc.

18. Protect your Workbook

Sometimes we want to protect the data in our file so that only we can change it. Here’s how to do this with VBA:

Congratulations! Since you are still reading this, you are really keen on learning VBA. As you have already seen for yourself, the VBA programming language is extremely useful and can save us a lot of time. I hope you found this information helpful and use it to become a master in MS Excel, VBA and computer software in general.