Microsoft KB Archive/164384

= Some Macro Commands Are Not Run in MS Internet Explorer =

Article ID: 164384

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition

-



This article was previously published under Q164384



SYMPTOMS
When you open a Microsoft Excel 7.0 workbook, some Visual Basic for Applications macro commands are not executed. When this occurs, you do not receive an error message. For example, if your macro contains a line of code similar to the following

MenuBars(xlworksheet).Menus("Tools").MenuItems.Add _ Caption:="test", OnAction:="mymacro"

the menu item "test" is not added to the Tools menu, and you do not receive an error message.

In addition, you are not able to switch to Visual Basic modules in your workbook.



CAUSE
These problems occur when all of the following conditions are true:


 * In Microsoft Internet Explorer, you click a hyperlink to your workbook, or you type a Uniform Resource Locator (URL) for your workbook in the Address box.

-and-
 * You configure Microsoft Internet Explorer so that Microsoft Excel files are opened in the Microsoft Internet Explorer window.

-and-
 * The macro commands are in an Auto_Open macro.

NOTE: In Microsoft Excel 97, you must use the Visual Basic Editor to view a module. -and-


 * Microsoft Excel 7.0 is installed on the computer on which you view the workbook.



RESOLUTION
To work around this problem, configure your Web browser to open Microsoft Excel files in a separate window. To do this with Microsoft Internet Explorer, use the following steps:


 * 1) On the View menu, click Options.
 * 2) Click the Programs tab, and then click File Types.
 * 3) Scroll through the Registered File Types list and click Microsoft Excel Worksheet. Then, click Edit.
 * 4) In the Edit File Type dialog box, clear the "Open web documents in place" check box. Then, click OK.
 * 5) Click OK in the "File Types" dialog box.
 * 6) Click OK in the Options dialog box.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem has been corrected in Microsoft Excel 97.



MORE INFORMATION
For additional information, please see the following article in the Microsoft Knowledge Base:

163901 : How to Configure Mac Internet Explorer to Open MS Excel Files

Additional query words: XL7

Keywords: kbprogramming KB164384

-

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

© Microsoft Corporation. All rights reserved.