Article ID: 918323 - Last Review: September 18, 2011 - Revision: 2.0

The EnableSelection property is not saved when you use a VBA macro to set the property in Excel 2002 or in Excel 2003

View products that this article applies to.

System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

SYMPTOMS

When you try to use a Microsoft Visual Basic for Applications (VBA) macro to set the EnableSelection property in Microsoft Excel 2002 or in Microsoft Office Excel 2003, the EnableSelection property is not saved. After the workbook is saved, closed, and then opened, cells that you expect to be locked can be selected.

If you set the EnableSelection property manually, the changes are saved. Additionally, locked cells cannot be selected when the workbook is opened.

Back to the top

RESOLUTION

Excel 2002

Back to the top

How to obtain the hotfix

This issue is fixed in the Excel 2002 post-Service Pack 3 Hotfix Package that is dated May 6, 2004. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

829348 (http://support.microsoft.com/kb/829348/ ) Excel 2002 post-Service Pack 3 hotfix package: May 6, 2004

Back to the top

Excel 2003

Back to the top

How to obtain the hotfix

This issue is fixed in the Excel 2003 post-Service Pack 1 Hotfix Package that is dated August 20, 2004. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

840316 (http://support.microsoft.com/kb/840316/ ) Description of the Excel 2003 post-Service Pack 1 hotfix package: August 20, 2004

Back to the top