Some Macro Commands Are Not Run in MS Internet Explorer (164384)


The information in this article applies to:

  • Microsoft Excel for Windows 95
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

Modification Type:MinorLast Reviewed:8/17/2005
Keywords:kbProgramming KB164384
©2004 Microsoft Corporation. All rights reserved.