<?xml version="1.0" encoding="UTF-8"?><!-- generator="WordPress/2.8.5" -->
<rss version="0.92">
<channel>
	<title>Excel Assist .co.uk</title>
	<link>http://www.excelassist.co.uk</link>
	<description>Excel hints, Excel tips and Excel assistance</description>
	<lastBuildDate>Fri, 26 Feb 2010 10:27:01 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>Microsoft Excel Date Tips</title>
		<description><![CDATA[Show Day Names With Your Dates (XL2000-XL2007)
If you ever need to show the name of the day in addition to the dates (e.g. Saturday, July 10) here are a couple of options.
Option 1: You can create a custom number format for the cells containing the dates
1) Press CTRL+1;
2) Select the Custom category;
3) In the Type [...]]]></description>
		<link>http://www.excelassist.co.uk/2010/microsoft-excel-date-tips/</link>
			</item>
	<item>
		<title>Adding the Excel Camera Tool to the Quick Access Toolbar &#8211; For Dummies</title>
		<description><![CDATA[The Excel Camera tool enables you to take a live picture of a range of cells that updates dynamically while the data in that range updates. Although Microsoft doesnt include the Excel Camera tool in the mainstream Ribbon, its quite useful when you want to build Excel dashboards and reports. Before you can use the [...]]]></description>
		<link>http://www.excelassist.co.uk/2010/adding-the-excel-camera-tool-to-the-quick-access-toolbar-for-dummies/</link>
			</item>
	<item>
		<title>Excel calculation on off button</title>
		<description><![CDATA[I decided I needed a button in my menu bar to turn calculations to manual or auto. As I am now using Excel 2007 the process to get to the Option dialogue is a little long winded.
So my code looks like this;

Sub CalcChangeStatus()
Cells(1, 1).Select
If Application.Calculation = xlManual Then
Application.Calculation = xlCalculationAutomatic
Else
Application.Calculation = xlManual
End If
End Sub

Add a [...]]]></description>
		<link>http://www.excelassist.co.uk/2010/excel-calculation-on-off-button/</link>
			</item>
	<item>
		<title>excel 2003 menu in 2007</title>
		<description><![CDATA[I found this tip today. If you&#8217;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
'  Delete it, if it exists
 [...]]]></description>
		<link>http://www.excelassist.co.uk/2010/excel-2003-menu-in-2007/</link>
			</item>
	<item>
		<title>sort by cell colour</title>
		<description><![CDATA[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 [...]]]></description>
		<link>http://www.excelassist.co.uk/2010/sort-by-cell-colour/</link>
			</item>
</channel>
</rss>
