XL5: File Opened by Dialog Box Macro Is Not Recognized as Open |
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.
- Open or unhide another file.
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
Additional query words: error application
Keywords :
Version : 5.00
Platform : WINDOWS
Issue type :
Technology :
Last Reviewed: September 14, 1999 |