I found this tip today. If you’re not getting on with the ribbon and need the old menus you are used to. Here is some code to add those menus.

http://spreadsheetpage.com/index.php/site/tip/old_style_menus_in_excel_2007/

Sub MakeOldMenus()
Dim cb As CommandBar
Dim cbc As CommandBarControl
Dim OldMenu As CommandBar

' Make it visible. It appears in the Add-Ins tab
Application.CommandBars("Old Menus").Visible = True
End Sub

Excel 2007 can sort and filter using the cell color (colour). By using a UDF you can do this in earlier version as well. VBA can get the interior color of the cell and report it as an index number from 1 to 56. Add this code into the VBA editor and add a column to you data with the formula =CellColor(A1).

Function CellColour(cell As Range)
CellColour = (cell.Interior.ColorIndex)
End Function


You can now sort or filter using this data. It’s not quite as clever as the latest version but you can still use colours to sort and filter.

You might find the following table helpful to understand the colours used in Excel. Thanks to www.mvps.org for the table.