Results 1 to 13 of 13

Thread: Custom Menu Bar

  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I borrowed a coworker's Personal.xls & Excel11.xlb files. ( I created them for her and now my computer crashed)

    The personal.xls works fine. All of the macros are there and function OK.

    I created a custom menu using the Customize/New and named it ReportsMenu

    My question is - how do I associate the Custom Menu Bar with the Excel11.xlb file?
    (Located at C:\Documents and Settings\AbramsM\Application Data\Microsoft\Excel (outside of the XLStart folder)


    Thank you very much for your help.

    Michael

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You could try opening the .xlb file and see if that works. If not, you'll probably have to reassign the macros to the toolbar buttons one by one.

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='786444' date='27-Jul-2009 12:39']You could try opening the .xlb file and see if that works. If not, you'll probably have to reassign the macros to the toolbar buttons one by one.[/quote]

    Looks like it's going to be 1 by 1. So sad..........

    Thanks Hans !

    Michael

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Excel stores the absolute path to the macros; it's different for you than for your coworker (since the path contains the username)...

  5. #5
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I created the custom toolbar (Reports)

    When I drag a custom button from Commands/Macros to the new toolbar, the title Reports goes away, and the macro IS the toolbar. There is no 'dropdown'. I hope I am describing this clearly).

    I cannot imagine what I am doing wrong. Can you assist?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Make sure that you drop the macro squarely on the toolbar and not beside it (the latter is easy to do if you want to add the button at the end, it has happened to me several times)

  7. #7
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='786454' date='27-Jul-2009 13:25']Make sure that you drop the macro squarely on the toolbar and not beside it (the latter is easy to do if you want to add the button at the end, it has happened to me several times)[/quote]
    This is so frustrating.

    When the toolbar is created, it appears 'on' the spreadsheet. I placed the button squarely on the toolbar.
    The title Reports still apears, and the button is 'in' the toolbar.
    When I drag the new toolbar up to the Standard toolbar, the button replaces the word Reports.

    I will keep trying though !!

    Thank you Hans.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    If a toolbar is docked at the top of the Excel window, like the Standard and Formatting toolbars are by default, its title (caption) isn't displayed, only the buttons. When you undock it (use the "handle" on the left hand side to drag it away from the top), the title bar will appear again. This is "normal" behavior for toolbars.

  9. #9
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='786459' date='27-Jul-2009 13:45']If a toolbar is docked at the top of the Excel window, like the Standard and Formatting toolbars are by default, its title (caption) isn't displayed, only the buttons. When you undock it (use the "handle" on the left hand side to drag it away from the top), the title bar will appear again. This is "normal" behavior for toolbars.[/quote]
    Wow !

    On my previous computer it sat right on the top menu bar and said Reports with a dropdown of the macros.

    It works fine now that I know this.

    Thank you Hans !

    Michael

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    [quote name='mrabrams' post='786463' date='27-Jul-2009 23:22']On my previous computer it sat right on the top menu bar and said Reports with a dropdown of the macros.[/quote]
    That makes me think that you created a custom menu named Reports, with the macros as menu items.

    To create a new menu, select New Menu in the list of categories in the Commands tab of the Customize window, then drag New Menu from the list of commands on the right to the menu bar (or to a toolbar). Right-click the new menu to change its name. You can then drag commands or macros to the new menu.

  11. #11
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I think you will benefit from reading my primer on custom toolbars and menus here:
    www.jkp-ads.com/articles/distributemacro03.asp

    In fact, seeing you are messing with other's personal.xls, I would start here:
    www.jkp-ads.com/articles/distributemacro00.asp
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  12. #12
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts
    First of all, I would like to thank Hans for your patience and pieterse for the tutorial.

    You guys are awesome and I really appreciate the time you take to share your knowledge (and patience)

    Very Sincerely,
    Michael Abrams

  13. #13
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You are very welcome!
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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