View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Hieb Steve Hieb is offline
external usenet poster
 
Posts: 27
Default VBE Menu Bar Visible But Not Functional

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