Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Embarressing Problem with Menus


Hi Again,

I'm really embarressed now. I wrote a MAcro to turn off all my too
bars and menus.

The turning off worked fine... but the turning back on didn't work.
Now I'm stuck and unable to turn anything on. I've tried righ
clicking but no toolbar options come up. I can't even access th
macros to try and figure out what went wrong.

I'm really stuck.

Please can anybody help me?

Geof

--
Wyver
-----------------------------------------------------------------------
Wyvern's Profile: http://www.excelforum.com/member.php...nfo&userid=574
View this thread: http://www.excelforum.com/showthread.php?threadid=52345

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,494
Default Embarressing Problem with Menus

i think this was from don:



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

--


Gary


"Wyvern" wrote in message
...

Hi Again,

I'm really embarressed now. I wrote a MAcro to turn off all my tool
bars and menus.

The turning off worked fine... but the turning back on didn't work.
Now I'm stuck and unable to turn anything on. I've tried right
clicking but no toolbar options come up. I can't even access the
macros to try and figure out what went wrong.

I'm really stuck.

Please can anybody help me?

Geoff


--
Wyvern
------------------------------------------------------------------------
Wyvern's Profile:
http://www.excelforum.com/member.php...fo&userid=5743
View this thread: http://www.excelforum.com/showthread...hreadid=523455



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default Embarressing Problem with Menus

search your drive for your *.xlb file. This holds menu customizations. If
you don't have any customizations you want to retain, you can just close
excel, then delete this file and reopen.

If you do have customizations you want to retain, then that isn't an option.

--
Regards,
Tom Ogilvy


"Wyvern" wrote:


Hi Again,

I'm really embarressed now. I wrote a MAcro to turn off all my tool
bars and menus.

The turning off worked fine... but the turning back on didn't work.
Now I'm stuck and unable to turn anything on. I've tried right
clicking but no toolbar options come up. I can't even access the
macros to try and figure out what went wrong.

I'm really stuck.

Please can anybody help me?

Geoff


--
Wyvern
------------------------------------------------------------------------
Wyvern's Profile: http://www.excelforum.com/member.php...fo&userid=5743
View this thread: http://www.excelforum.com/showthread...hreadid=523455


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Embarressing Problem with Menus


Awesome, thanks guys. I won't actually be able to try this until I ge
to work. But thanks for your responses, I'll let you know how I go.

Geof

--
Wyver
-----------------------------------------------------------------------
Wyvern's Profile: http://www.excelforum.com/member.php...nfo&userid=574
View this thread: http://www.excelforum.com/showthread.php?threadid=52345

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
Drop Down Menus - 2nd Problem Neil M Excel Worksheet Functions 3 November 19th 05 04:40 PM
Problem with Pivot Table Drop-Down Menus Mac Excel Worksheet Functions 4 November 7th 04 01:18 PM
Problem with IE menus after installing excel macros Michael Moyna Excel Programming 1 July 17th 04 01:00 AM
Overriding Actions of Excel DropDown Menus and Poup Menus Von Shean Excel Programming 2 February 3rd 04 06:43 AM


All times are GMT +1. The time now is 10:14 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"