Office 2007 - Revision history

Rkdrm at 05:58, 12 July 2011

2011-07-12T05:58:06Z

Rkdrm at 06:50, 23 November 2010

2010-11-23T06:50:39Z

Rkdrm at 02:46, 16 June 2010

2010-06-16T02:46:52Z

Rkdrm at 07:03, 30 March 2010

2010-03-30T07:03:25Z

Rkdrm at 01:56, 30 March 2010

2010-03-30T01:56:52Z

Rkdrm: New page: * [http://office.microsoft.com/training/Training.aspx?AssetID=RP101482341033&CTT=6&Origin=RC101482291033 Quick Reference Card - Up to speed with the 2007 Microsoft® Office system]

2008-12-10T06:25:23Z

New page: * [http://office.microsoft.com/training/Training.aspx?AssetID=RP101482341033&CTT=6&Origin=RC101482291033 Quick Reference Card - Up to speed with the 2007 Microsoft® Office system]

New page

* [http://office.microsoft.com/training/Training.aspx?AssetID=RP101482341033&CTT=6&Origin=RC101482291033 Quick Reference Card - Up to speed with the 2007 Microsoft® Office system]

← Older revision		Revision as of 05:58, 12 July 2011
Line 1:		Line 1:
		+	* Excel C# Interop, Suppress "The number in this cell is formatted as text or preceded by an apostrophe" error:
		+
		+	public static void SetCellText(Range cell, string text)
		+	{
		+	cell.NumberFormat = "@";
		+	cell.Value = text;
		+	// Suppress "The number in this cell is formatted as text or preceded by an apostrophe"
		+	for (int i = 1; i <= 7; i++)
		+	{
		+	cell.Errors.Item[i].Ignore = true;
		+	}
		+	}
		+
	* [http://office.microsoft.com/training/Training.aspx?AssetID=RP101482341033&CTT=6&Origin=RC101482291033 Quick Reference Card - Up to speed with the 2007 Microsoft® Office system]		* [http://office.microsoft.com/training/Training.aspx?AssetID=RP101482341033&CTT=6&Origin=RC101482291033 Quick Reference Card - Up to speed with the 2007 Microsoft® Office system]
	* If Outlook 2007 comes up with a message saying "Cannot create Outlook window", a possible fix is to run the following from the command line:		* If Outlook 2007 comes up with a message saying "Cannot create Outlook window", a possible fix is to run the following from the command line:

← Older revision		Revision as of 06:50, 23 November 2010
Line 15:		Line 15:
	===== Microsoft Word =====		===== Microsoft Word =====
	* [http://support.microsoft.com/kb/290953 How to number chapters, appendixes, and pages in documents that contain both chapter and appendix headings in Word]		* [http://support.microsoft.com/kb/290953 How to number chapters, appendixes, and pages in documents that contain both chapter and appendix headings in Word]
		+
		+	==== Removing an Excel Workbook VBA Password ====
		+
		+	A VBA project password can be removed with a hex editor. Close the workbook and open the workbook file in the hex editor. Find the string "DPB" and change it to "DPx". Save the file. Open the workbook and click OK until the workbook is open (one or more dialogs are displayed describing various problems with the VBA project). Press ALT+F11, choose the menu command Tools->VBAProject Properties, navigate to the Protection tab, and change the password but do not remove it (note the new password). Save, close, and re-open the workbook. Press ALT+F11 and enter the new password. Choose Tools->VBAProject Properties, navigate to the Protection tab, and remove the password. Save the workbook.

← Older revision		Revision as of 02:46, 16 June 2010
Line 12:		Line 12:
	** Click the Blanks option and click OK. This will select all blank cells in the range you had previously selected.		** Click the Blanks option and click OK. This will select all blank cells in the range you had previously selected.
	** Now choose Edit, Delete, select the Entire Row option and click OK.		** Now choose Edit, Delete, select the Entire Row option and click OK.
		+
		+	===== Microsoft Word =====
		+	* [http://support.microsoft.com/kb/290953 How to number chapters, appendixes, and pages in documents that contain both chapter and appendix headings in Word]

← Older revision		Revision as of 07:03, 30 March 2010
Line 4:		Line 4:
	outlook.exe /resetnavpane		outlook.exe /resetnavpane
	</code>		</code>
		+	* To delete blank rows in Excel:
		+	** First, before you make any drastic changes to any workbook always make sure you have a backup copy or a recently saved copy in case you need to restore the original data .
		+	** Now, select the cells in one column from the top of your list to the bottom.
		+	** Make sure that all the blank cells in this selected range are the rows you want to delete.
		+	** Press the F5 key on your keyboard (or select Edit, Goto).
		+	** Click the Special button.
		+	** Click the Blanks option and click OK. This will select all blank cells in the range you had previously selected.
		+	** Now choose Edit, Delete, select the Entire Row option and click OK.

← Older revision		Revision as of 01:56, 30 March 2010
Line 1:		Line 1:
	* [http://office.microsoft.com/training/Training.aspx?AssetID=RP101482341033&CTT=6&Origin=RC101482291033 Quick Reference Card - Up to speed with the 2007 Microsoft® Office system]		* [http://office.microsoft.com/training/Training.aspx?AssetID=RP101482341033&CTT=6&Origin=RC101482291033 Quick Reference Card - Up to speed with the 2007 Microsoft® Office system]
		+	* If Outlook 2007 comes up with a message saying "Cannot create Outlook window", a possible fix is to run the following from the command line:
		+	<code>
		+	outlook.exe /resetnavpane
		+	</code>