Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / October 2005

Tip: Looking for answers? Try searching our database.

HELP!!!! Lost Menu Bar!!!! Please Help (sob)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rick, United Kingdom - 14 Aug 2005 22:02 GMT
My 5 year old son got onto my computor while i was away!!! he managed to
remove all the Buttons and toolbars from Word and Excel! including the menu
bar buttons (File, Edit etc). I got the standard toolbar buttons back, but
the menu bar buttons have completly gone! How do i get them back? I am blind
with out them!!!!

HELLLLLLLP!!!
Bob Phillips - 14 Aug 2005 23:52 GMT
Excel - in the VB IDE (Alt-F11), open the immediate window (Ctrl-G), and
type

Application.Commandbars(1).Enabled = True

Signature

HTH

RP
(remove nothere from the email address if mailing direct)

> My 5 year old son got onto my computor while i was away!!! he managed to
> remove all the Buttons and toolbars from Word and Excel! including the menu
[quoted text clipped - 3 lines]
>
> HELLLLLLLP!!!
Rick, United Kingdom - 15 Aug 2005 21:28 GMT
Hi, I did as you said, but nothing happened! I still don't have the File Edit
etc.
i typed as exactly as you displayed it. should i add the (-- RP) thing
though when i tried that said there was an incomplete sub form.
hoping for a response.

> Excel - in the VB IDE (Alt-F11), open the immediate window (Ctrl-G), and
> type
[quoted text clipped - 10 lines]
> >
> > HELLLLLLLP!!!
Rick, United Kingdom - 15 Aug 2005 21:56 GMT
Maybe i should add that i am using Office 2000 Pro. I am also purchasing
Office 2003 Pro if this problem is not solved should i install over office
2000 and will the same problem arise in office 2003?
Or should i uninstall Office 2000 first (including root files)?

> Hi, I did as you said, but nothing happened! I still don't have the File Edit
> etc.
[quoted text clipped - 16 lines]
> > >
> > > HELLLLLLLP!!!
Bob Phillips - 15 Aug 2005 21:58 GMT
No just the Application line.

Signature

HTH

RP
(remove nothere from the email address if mailing direct)

> Hi, I did as you said, but nothing happened! I still don't have the File Edit
> etc.
[quoted text clipped - 16 lines]
> > >
> > > HELLLLLLLP!!!
Rick, United Kingdom - 15 Aug 2005 22:16 GMT
Ok did that. and still nothing happened so i did the obvious! and pressed
enter. the follloing message popped up in a window:

Complie error;
Expected; indentifier or bracketed expression.

I am sorry to be a pain. but i really am lost now!

> No just the Application line.
>
[quoted text clipped - 22 lines]
> > > >
> > > > HELLLLLLLP!!!
Dave Peterson - 15 Aug 2005 22:47 GMT
Is this the line you used?

Application.Commandbars(1).Enabled = True

(Did you copy and paste or did you type it in.  I'm guessing a typo error.  I'd
try again!)

> Ok did that. and still nothing happened so i did the obvious! and pressed
> enter. the follloing message popped up in a window:
[quoted text clipped - 45 lines]
> > > > >
> > > > > HELLLLLLLP!!!

Signature

Dave Peterson

Rick, United Kingdom - 15 Aug 2005 23:10 GMT
ok so there may have been a typo. but this time i copied and pasted. no error
pop up. But still no File, Edit. etc. I pressed return and it just moved the
curser down. to the next line in the editor.
What am i doing wrong? I have even tried reinstalling after taking all trace
of office off my machine but the same thing happens it starts up with no
command bar buttons. Is my pc doomed never to run office again?? what will
happen when i install office 2003? (beginning to sob again)

> Is this the line you used?
>
[quoted text clipped - 52 lines]
> > > > > >
> > > > > > HELLLLLLLP!!!
Dave Peterson - 16 Aug 2005 00:29 GMT
It might be easier to just destroy the existing *.xlb file (where excel stores
customizations) and recreate it at your leisure.

Close excel
windows start button|search|
look for *.xlb
(remember to look in hidden folders, too!)

If you want, rename all you find to *.xlbOLD (just in case).

Then restart excel.

If it worked ok, delete those *.xlbOLD files.

If it didn't work ok, close excel and rename them back to *.xlb (no harm, no
foul).

> ok so there may have been a typo. but this time i copied and pasted. no error
> pop up. But still no File, Edit. etc. I pressed return and it just moved the
[quoted text clipped - 64 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Pecas - 28 Oct 2005 10:56 GMT
I had exactly the same problem and destroying the xlb was the solution.
Thank you very much Dave
German Vivanco
Spain

> It might be easier to just destroy the existing *.xlb file (where excel stores
> customizations) and recreate it at your leisure.
[quoted text clipped - 81 lines]
> > >
> > > Dave Peterson
Dave Peterson - 28 Oct 2005 15:23 GMT
Google is your friend!

Glad you found it.

> I had exactly the same problem and destroying the xlb was the solution.
> Thank you very much Dave
[quoted text clipped - 90 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.