MrExcel Publishing
Your One Stop for Excel Tips & Solutions

invalid instruction


Posted by Allan Greenberg on February 12, 2001 12:23 PM

In Excel 97, I was trying to set up a different start up workbook in Tools- Options- General- Alternate Start up File Location. I may have typed the path to the file incorrectly, because now when I try to open Tools, Options, I get;
This program has preformed an illegal operation. Excel executed an invalid instruction in module (unknown) at (mem location).

Does anyone have any idea how to fix my problem, and is the reason I'am getting the error because I typed the path incorrectly.
Thanks for your assistance
Allan


Posted by Celia on February 12, 2001 2:50 PM

Allan
Try this (from http://support.microsoft.com/support/kb/articles/Q157/7/69.):-

Use the following steps to reset a menu item that has been modified:
1. On the Tools menu, click Customize.
2. Click the Commands tab.
3. Click the appropriate menu. Then, right-click the menu item that you want to reset.
4. On the shortcut menu, click Reset.
The menu item is reset to its original settings. When you are done making changes, click Close.


Or try running this macro :-
Sub ResetMenu()
Application.CommandBars("Tools").Reset
End Sub

Celia