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

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.

Excel 2002

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:

Excel 2003

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:

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.