Article ID: 137259
Article Last Modified on 8/17/2005
APPLIES TO
- Microsoft Office 95 Standard Edition
- Microsoft Office 95a
- Microsoft Office 95b
- Microsoft Binder for Windows 95
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 95a
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 5.0 Standard Edition
- Microsoft Excel 5.0c
This article was previously published under Q137259
SYMPTOMS
When you add a Microsoft Excel section from an existing file to a Microsoft Binder, any auto_open or auto_close macros in the Microsoft Excel file are run when the section is being added to the binder. However, if you open a Microsoft Binder file that has an existing Microsoft Excel section that contains auto_open or auto_close macros, those macros will not run either when you open the binder file or when you activate/deactivate the Microsoft Excel section.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
MORE INFORMATION
When a Microsoft Excel file has been saved while a module sheet is active, all of the auto macros will run when the file is added to a Microsoft Binder. The auto_close macro runs each time the Microsoft Binder file is closed. If the Microsoft Excel file is saved while a worksheet, dialog sheet, Microsoft Excel 4.0 macro sheet, or chart sheet is active, auto macros are not run after the section has been added.
REFERENCES
For additional information, please see the following article(s) in the Microsoft Knowledge Base:
135249 Cannot Write/Edit Visual Basic for Applications Code in Binder
Additional query words: off7 xl7 7.00a 7.00b 8.00 97
Keywords: KB137259
