MS-Excel - General Formatting Tutorials

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