MS-Excel - General Formatting Tutorials

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.

With this tutorial, you can add the Calendar Control to any Excel workbook.

Using a bit of code, you can easily SUM or COUNT cells whose fill color was specified manually.

Sometimes it's difficult to make choices with checkboxes. Fortunately, you can simplify this process using a basic bit of code.

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.

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?

Instead of giving every button its own macro, it's sometimes more convenient to create a single macro that manages all the buttons.

Sometimes you need to create a macro that will work even if the sheet names that it references change.

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.

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.