XL97: Blank Line Inserted into Module
Article ID: 186253
Article Last Modified on 10/11/2006
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q186253
SYMPTOMS
When you open a Microsoft Excel workbook that contains a Visual Basic
module, a blank line is inserted at the beginning of the module.
CAUSE
This problem occurs when all of the following conditions are true:
- Your workbook contains a Visual Basic module.
-and-
- The workbook is in the Microsoft Excel 5.0/95 Workbook file format.
-and-
- You open the workbook in Microsoft Excel 97.
-and-
- You continue to save the workbook in the Microsoft Excel 5.0/95 Workbook
file format.
Each time you save, close, and reopen your workbook, a new blank line is
inserted at the top of the module.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
This problem no longer occurs in Microsoft Excel 2000.
Additional query words: XL97 empty
Keywords: kbbug kbpending kbprogramming KB186253