XL5: File Opened by Dialog Box Macro Is Not Recognized as Open

ID: Q110560

5.00 WINDOWS kbusage

The information in this article applies to:

- Microsoft Excel for Windows, version 5.0

SYMPTOMS

When you use a Visual Basic or a Microsoft Excel 4.0 macro assigned to a button or other item in a dialog box to open a file, the File and Help menus may be the only menus displayed on the menu bar. This behavior is incorrect; when you open a non-hidden workbook, the workbook menu bar should be displayed.

When you attempt to edit or close the open workbook, you may receive a general protection (GP) fault.

WORKAROUNDS

To open the file so that worksheet menu bar is visible, do any of the following:

• Click the title bar of the document or resize the document window.

  -or-

• Open or unhide another file.

  -or-

• In the macro that called the dialog box, activate the workbook window after you use the Dialog.Show command. For example, use the following command:

        Workbooks("bookname").Activate
  

REFERENCES

KBCategory: kbusage KBSubcategory:

Additional reference words: 5.00 error application

Version           : 5.00
Platform          : WINDOWS

Last Reviewed: September 14, 1996