Steve,
Search for and delete files names *.xlb. It is in these files
where toolbar customizations are stored and they are corrupted
from time to time.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Steve Hieb" wrote in message
om...
This problem is with the Visual Basic Editor. I already tried
to
Customize/Reset with no luck. Actually, I can't event unckeck
the
Menu Bar or remove it. Its simply visible, but froze or
disabled.
The Menu Bar is there, but when you try to select any heading
nothing
happens (File, Edit, View ...). All the other toolbars work
fine.
I was playing around with the VBE object to learn more about
it.
Wrote code to Goto a specific line in VBE. Nothing unusual and
it
worked. The only other thing I did was create a new toolbar
manually
(not programmatically). Occasionally when I try to Reset the
Menu Bar
and/or remove the new toolbar I get an Application Error:
The exception Privileged instruction. (0x0000096) occurred in
the
application at location 0x306db860.
I've tried everything. I'm on Excel 97 w/ NT. FYI, the
Reference to
VBA Extensibility 5.3 is now unchecked. This had to have been
caused
by me playing around w/ the VBE object or creating the custom
toolbar.
FYI, the custom toolbar has nothing in it w/ the caption
"GOTO".
Here is some code I used, which worked fine. Shortly after I
did it I
moved on and then noticed the Menu bar was disabled. Nothing
spectacular.
Sub GotoLine()
Dim Ln As Variant
Ln = Application.InputBox("Enter Line:", "GOTO")
If Ln = False Then Exit Sub
Application.VBE.CodePanes(1).SetSelection Ln, 1, Ln, 1
End Sub
I'm going to have to re-install unless someone has ideas. Is
there a
file like "Personal.xls" that I can delete or something to
reset
everything? What's also weird is I can't find the Personal.xls
file.
I wasn't messing around with it, but maybe that has something
to do
with it.
TIA,
Steve Hieb