MS-Excel Tutorials

Subcategoreis

subcategoryExcel 2003
subcategoryFunctions and Formula
subcategoryGeneral Formatting
subcategoryGetting Started

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...

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...