Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Nov 2001
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Menu Item Appears Twice, Sometimes (Excel 2000 / Various Wins)

    I am working on three computers - all have Excel 2000, two have Win98, one has WinXP. I created a workbook (called it personal.xls) with an auto_open that adds a menu item to the Excel standard File/Edit/View menu bar. The code was copied from a tutorial site (John Walkenback or Chip Pearson) and I just changed the name of the macro that the button activated. Well, on the one Win98/Excel2000 computer, when I open personal.xls, voila, there's my menu item. When I open it on the WinXP/Excel2000, also no problem. BUT when I open it on the other Win98/Excel 2000 computer, the menu item is added to the menu bar TWICE. This happened both when opening the file from a floppy diskette and when launching Excel from the start menu with this file saved in C:Program FilesMS OfficeOfficeXLStart
    I would dearly love to know why it's appearing twice, and would be very grateful to whomever could enlighten me!

    Regards
    Mary Brodd

  2. #2
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Menu Item Appears Twice, Sometimes (Excel 2000 / Various Wins)

    If you rename or delete the username9.xlb file (in c:windows) on the "bad" computer, does that solve it?
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  3. #3
    New Lounger
    Join Date
    Nov 2001
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Menu Item Appears Twice, Sometimes (Excel 2000 / Various Wins)

    I don't have access to that computer right at this moment, but I will definitely try your suggestion.
    Thanks!

    (Would that explain also why it ignored my OnError , a detail I see I neglected to mention?)

    Regards
    Mary Brodd

Posting Permissions

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