Distribute Macros
Although you can distribute a macro along with a workbook, if you want to distribute only the macro's functionality, an Excel add-in is the way to go. Read more...
MS-Excel Tutorials
Subcategoreis
Excel 2003 Functions and Formula General Formatting Getting Started
Run Procedures on Protected Worksheets
Excel macros are a great way to save time and eliminate errors. However, sooner or later you might try to run your favorite Excel macro on a worksheet that has been protected, with or without a password, resulting in a runtime error. Read more...
Excel's Three-Criteria Limit for Conditional Formatting
You can use VBA to tutorial conditional formatting to use more than three criteria on your data. In fact, you can use the code to apply virtually an unlimited number of criteria. Read more...
Retrieve a Workbook's Name and Path
Every now and then you might want a cell to return the name of a workbook, or even the workbook's filename and path. With this tutorial, it's easy to retrieve a workbook's name and path. Read more...
Password-Protect and Unprotect All Excel Worksheets
There is no standard feature in Excel that will enable you to protect and unprotect all worksheets in one go; however, some simple code can make it happen. Read more...
Excel Calendar Control to Any Excel Workbook
The Excel Calendar Control can make things easier for both you and the users of the spreadsheet. With this tutorial, you can add the Calendar Control to any Excel workbook. Read more...
Count or Sum Cells That Have a Specified Fill Color
Using a bit of code, you can easily SUM or COUNT cells whose fill color was specified manually. Read more...
Cell Ticked or Unticked upon Selection
Sometimes it's difficult to make choices with checkboxes. Fortunately, you can simplify this process using a basic bit of code. Read more...
Excel Display a "Please Wait" Message
Have you ever had one of those macros that seem to take forever to complete? If this is a problem with your macro, you can have Excel display a "Please Wait" message to the user. Read more...
Create a Workbook Splash Screen
Splash screens provide that extra bit of polish to an application-not to mention that they keep you entertained while the application loads. Why shouldn't a spreadsheet do the same? Read more...
Connect Buttons to Macros Easily
Instead of giving every button its own macro, it's sometimes more convenient to create a single macro that manages all the buttons. Read more...
Use CodeNames to Reference Sheets in Excel Workbooks
Sometimes you need to create a macro that will work even if the sheet names that it references change. Read more...
Run a Macro at a Set Time
Many times it would be great to run a macro at a predetermined time or at specified intervals. Fortunately, Excel provides a VBA method that makes this possible. Read more...
Speed Up Code While Halting Screen
When you record macros from within Excel, the code it generates often produces screen flicker, which not only slows down your macro, but also makes the macro's activity look very disorganized. Read more...
Evaluate a Text Equation
By using an old Excel4 macro function called EVALUATE in a special way, you can easily evaluate text equations (an equation formatted as text and interpreted as such by Excel) as actual calculations. Read more...