Microsoft KB Archive/918323

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

Article ID: 918323

Article Last Modified on 10/15/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition
 * Microsoft Office Excel 2003

-





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.



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 Excel 2002 post-Service Pack 3 hotfix package: May 6, 2004

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 Description of the Excel 2003 post-Service Pack 1 hotfix package: August 20, 2004



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Additional query words: XL2007 XL2003 XL2002

Keywords: kbbug kbfix kbqfe kbprogramming kbpubtypekc kboffice2003sp2fix KB918323

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.