Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default No menus, no toolbars, no nothing!!

HELP!

I was playing around with some macros for disabling some menu items and
I've really screwed something up. Now, whenever I start Excel, all I
have is the worksheet and formula bar. No toolbars, menus,
shortcuts... I can start VB by pressing ALT+F11, but I can't find the
code that is causing the problem.

How do I get everything back to normal, without re-installing Excel.
Our help desk would kill me.

Thanks so much in advance.

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,337
Default No menus, no toolbars, no nothing!!

Try this

hit alt-f11

hit ctrl-g (to see the immediate window)
type this and hit enter:
application.commandbars("worksheet menu bar").Enabled = true
=======

then
tools|customize|toolbars tab


--
Don Guillett
SalesAid Software


"CR" wrote in message
ups.com...
HELP!

I was playing around with some macros for disabling some menu items and
I've really screwed something up. Now, whenever I start Excel, all I
have is the worksheet and formula bar. No toolbars, menus,
shortcuts... I can start VB by pressing ALT+F11, but I can't find the
code that is causing the problem.

How do I get everything back to normal, without re-installing Excel.
Our help desk would kill me.

Thanks so much in advance.



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default No menus, no toolbars, no nothing!!

right click on a blank area of the Worksheet or formula bar and you should
see a list of toolbars. Select the ones you want to be visible.

also you can select customize, then in the first tab, select Worksheet Menu
Bar and click the reset button.

--
Regards,
Tom Ogilvy

"CR" wrote in message
ups.com...
HELP!

I was playing around with some macros for disabling some menu items and
I've really screwed something up. Now, whenever I start Excel, all I
have is the worksheet and formula bar. No toolbars, menus,
shortcuts... I can start VB by pressing ALT+F11, but I can't find the
code that is causing the problem.

How do I get everything back to normal, without re-installing Excel.
Our help desk would kill me.

Thanks so much in advance.



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default No menus, no toolbars, no nothing!!

You're a life-saver. Thanks so much, Don! Have a great weekend.

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,337
Default No menus, no toolbars, no nothing!!

glad it helped


--
Don Guillett
SalesAid Software

"CR" wrote in message
oups.com...
You're a life-saver. Thanks so much, Don! Have a great weekend.



Reply
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
Menus and Toolbars Needy Ned Excel Discussion (Misc queries) 1 November 6th 08 04:45 PM
Cannot unhide toolbars/menus Lisa Excel Discussion (Misc queries) 1 December 21st 07 10:40 AM
Missing menus and toolbars Graham Haughs Excel Discussion (Misc queries) 1 December 23rd 05 07:53 PM
ToolBars and Custom Menus Newbie Excel Programming 1 April 14th 04 04:04 PM
Restricting use of menus and toolbars Brian Excel Programming 1 October 31st 03 04:51 PM


All times are GMT +1. The time now is 11:14 PM.

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

About Us

"It's about Microsoft Excel"