Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Sep 2001
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Insert|Name|Define (Excel 2000 SR-1a)

    I've lost the "define" option from Insert|Name|Define.

    Any ideas on how to get it back?

    I've tried Customize|Options|Reset to no avail.

    Many Thanks
    stevej
    tampa fl

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert|Name|Define (Excel 2000 SR-1a)

    Is it missing or just grayed out. If it is missing, try running the macro below:

    <pre>Private Sub ResetMenuBar()
    Application.CommandBars("Worksheet Menu Bar").Reset
    End Sub
    </pre>

    Legare Coleman

  3. #3
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Insert|Name|Define (Excel 2000 SR-1a)

    stevej

    You are sure that the worksheet/book is not protected?

    Wow!!! Its in a sub menu so what happened to the other items in that submenu?

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  4. #4
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Insert|Name|Define (Excel 2000 SR-1a)

    stevej

    Sorry I did not look at the version number, but have you used it recently. In Excel 2000 and > you have the option to display the recently used commands first. To undo this Click to clear the Menus show recently used commands first check box in Tools|Options.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  5. #5
    New Lounger
    Join Date
    Sep 2001
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert|Name|Define (Excel 2000 SR-1a)

    Your short macro did the trick.

    Many thanks for your quick, helpful and correct response.

    stevej
    tampa fl

  6. #6
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Insert|Name|Define (Excel 2000 SR-1a)

    As a side note... One of the first things that I do after installing Excel is to unselect the 'recently used commands' option and enable the full menus to be shown immediately. I personally hate having to wait for the menus to expand; the faster computers get, the more impatient I become. It also makes it even harder to help someone else troubleshoot their own Excel problems when I tell them to go to blahblahblah command and they can't see it in their menus -- and then they start thinking that I'm full of <img src=/w3timages/censored.gif alt=censored border=0> before I can explain to them how to get the full menus to display first. <img src=/S/headthrob.gif border=0 alt=headthrob width=15 height=15>

  7. #7
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert|Name|Define (Excel 2000 SR-1a)

    Similar to being mad at the microwave for taking 30 secs instead of 20 mins in the oven? <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15> Just joking!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •