View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default VBE Menu Bar Visible But Not Functional

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