Protect VBA code with password

Posted on April 18, 2016 by Wyman W

This Excel VBA tutorial explains how to protect VBA code with password. You may also want to read: Excel VBA protect worksheet with password Excel VBA hide worksheet with password (xlVeryHidden) Excel VBA Add password to Excel workbook in folder Protect VBA code with password When you write Macro / VBA code in Excel, other people can easily see the source code by clicking ALT+F11 and then copy / modify your code. If you do not want anyone to see the VBA code (to steal your hard wo...

Create Excel Add-in and add in Ribbon

Posted on June 14, 2015July 7, 2015 by Wyman W

This Excel tutorial explains how to add Excel Add-in in Ribbon. You may also want to read: Writing your first Excel Macro by recording Macro Why use Excel Add-in After you have created a Macro (Sub Procedure), you may want to distribute it for users to use. You can simply add the VBA code in the Module of a Workbook and then distribute the Workbook, but the problem is that the Macro cannot be used in other Workbook. Depending on the situation, you may want to distribute a Macro is thr...

Excel VBA Option Explicit to force declaration of variables

Posted on February 4, 2015January 30, 2017 by Wyman W

This tutorial explains how to use Option Explicit to force declaration of variables in Excel VBA (enable Require Variable Declaration) You may also want to read: Difference between Dim and Set Difference between ByRef ByVal Function, Sub, Method, Property Differences What is VBA Option Explicit? Option Explicit is a keyword declared on top of the Visual Basic Editor in the coding Windows outside any Procedures. In the presence of Option Explicit keyword, all variables must be de...

Excel VBA Assign hotkey to Macro using OnKey Method

Posted on January 22, 2015March 1, 2015 by Wyman W

What is Macro? Macro is a set of actions that are intended to be repeating all over again. Macro is not a word just for Excel, you can find many other software help users record a set of actions for Windows or even for specific games. The first Macro I used was EZ Macro about 15 years ago, which helped me repeat a set of actions in an online game endlessly in order to get my skill points up. Today I still use keyboard and mouse that can record Macro. Excel is very kind to have a built-in Rec...

Add Excel Developer Tab

Posted on January 11, 2015January 30, 2017 by Wyman W

This Excel tutorial explains the use of Excel Developer Tab and how to add Excel Developer Tab for Excel 2007, 2010 and 2013. What is Excel Developer Tab? Excel Developer tab is a category in menu bar which contains everything you need regarding Macro, such as recording Macro, inserting Controls (button, text box, drop down list, etc), view the Property of Control. Below is a screenshot of Excel 2013 Developer Tab. In Excel 2003, you can find everything under "Tools" > "Customize", ...

Excel Record Macro

Posted on January 5, 2015January 11, 2015 by Wyman W

What is Macro and what is Excel Record Macro function? Macro is a set of actions that is intended to be repeating all over again. Macro is not a word just for Excel, you can find many other software help users record a set of actions for Windows or even for specific games. The first Macro I used was EZ Macro about 15 years ago, which helps me repeat a set of actions in an online game endlessly in order to get my skill points up. Today I still use keyboard and mouse that can record Macro...

Change font color and format in Visual Basics Editor VBE

Posted on December 6, 2014March 2, 2015 by Wyman W

This tutorial explains how to change font color and formats in Visual Basics Editor (VBE) to make your VBA code more readable. This article is suitable for Excel and Access. Change the VBE font color and format, why? Depending on the color and brightness setting of your monitor, the default font color in VBE (Visual Basic Editor) is not always easy to read. It is possible to change the VBE font color and format, for different types of codes, such as comment, syntax error, identifier, etc. ...