The macro created in this tutorial will apply a number of formatting options to a worksheet title. In Excel 2007 and 2010, ...
spreadsheets.about.com