Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Custom menu puzzle (XL2000 SR1)

    When I add a new item to one of my custom menus by dragging the yellow face from the macro category commands onto the menu then assigning a macro to the button, the button & macro do not appear next time I start XL.
    I have renamed my Excel.xlb file before closing XL, and I can see that a new Excel.xlb file is created at XL shutdown but the new button still does not appear on restart.

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Custom menu puzzle (XL2000 SR1)

    Here is a partial explanation. The new Excel.xlb is being saved in Cocuments and SettingsmikeApplication DataMicrosoftExcel, and when I open this file new button and macro appear. So XL is not taking the .xlb at startup from there, this is the opposite of what has happened with previous versions of XL

Posting Permissions

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