MS-Excel - General Formatting Tutorials

This tutorial describes how to move, delete, and rename worksheets, as well as protect them from being edited or altered.

The rest of this tutorial takes you through the three most common control types supported by the Ribbon interface: buttons, menus, and split buttons. You'll learn the RibbonX XML code required to add and configure each control, as well as the VBA code nee

This tutorial presents some techniques for making your macros more accessible. Learn how to enable your users to use familiar tools-namely, the Office 2007 Ribbon and its tabs, groups, and various buttons to run your macros.

By default, Excel VBA code is case sensitive and uses what is known as binary comparisons. This means that it sees Cat and cat as two different words.

Use a custom function to display the criteria used for any column in a table with an AutoFilter applied.

Restrict all future entries in a spreadsheet or range of cells to uppercase or proper case only.

When using a built-in Excel function is impractical, you can use a custom macro to change any existing text to uppercase or proper case.

Attach a custom toolbar to your spreadsheet that doesn't get in the way of the end user's settings for other spreadsheets when yours is closed.

Change absolute formula references to relative references, vice versa, or a mix of absolute and relative columns and rows.

To overcome the limitations of the Track Changes feature, you can employ some help from Excel VBA and Excel's Change Events feature.