The EnableSelection property is not saved when you use a VBA macro to set the property in Excel 2002 or in Excel 2003 (918323)
The information in this article applies to:
- Microsoft Excel 2002
- Microsoft Office Excel 2003
SYMPTOMSWhen 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.RESOLUTIONExcel 2002How to obtain the hotfixThis 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 Excel 2003How to obtain the hotfixThis 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 STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
| Modification Type: | Minor | Last Reviewed: | 9/23/2006 |
|---|
| Keywords: | kbProgramming kbOffice2003SP2fix kbQFE kbbug kbfix kbpubtypekc KB918323 kbAudITPRO kbAudEndUser |
|---|
|