LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel "text to columns needs" a menu-visible on/off switch Nate Setting up and Configuration of Excel 0 October 8th 09 06:23 PM
Which is Better / More Functional / Accurate Rob Excel Worksheet Functions 2 April 9th 09 06:17 PM
Excel 2007 Nearly Non Functional Desert Doug Excel Discussion (Misc queries) 10 June 10th 07 05:39 AM
The menu bar is not visible & right click doesnt work Rohit Jain Excel Discussion (Misc queries) 1 April 7th 06 07:41 AM
Non-functional Popup Menu Boxes Jim_M Charts and Charting in Excel 0 January 20th 05 04:27 PM


All times are GMT +1. The time now is 03:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"