Toolbar help sought! (Resolved)
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Toolbar help sought! (Resolved)

  1. #1
    Board Regular Jak's Avatar
    Join Date
    Apr 2002
    Location
    Newcastle upon Tyne
    Posts
    796
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    In Excel I go to customized, new menu and drag the new menu to the toolbar. Once the new menu is in place I go to macro and drag and drop several buttons to make the menu a drop down menu for the macros. Once this is done I assign each button a name and then assign the relevant macro to the button.

    This is straight forward enough, but is a little long winded when it has to be done to a large number of PC’s. I have saved my personal.xls and have a .bat file that loads it onto each PC to allow access to the macros and update them as required. What would be better is a method of loading a drop down menu to the Excel toolbar with macro’s assigned. Please note I do not wish to load a saved workbook with the macro menu built in to the On_Open function. The method should be built into Excel or a .bat method if possible. Any ideas on how to tackle this problem would be welcomed.


    [ This Message was edited by: Jak on 2002-05-15 06:27 ]

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How about creating an Excel Add-in instead?

  3. #3
    Board Regular Jak's Avatar
    Join Date
    Apr 2002
    Location
    Newcastle upon Tyne
    Posts
    796
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Mark

    have you got an example of using the add in function to create a toolbar?

  4. #4
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm curious.

    Why no On_Open? When it's a personal.xls file, user's aren't prompted for macros...
    ~Anne Troy

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Please note I do not wish to load a saved workbook with the macro menu built in to the On_Open function

    i understand but on-open is dangerouse via Personal xls, many IT dept crunch these as they are used via virus code writters, i only to day passage saying what i though of free anti virus OK most was Excel leant but proove my pont. no i will never explain theis, but suggest against this one. Anyone telling different needs to have virus experience, bar one attack

    my youngest son needs me 13 months ill update this more later

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  6. #6
    Board Regular
    Join Date
    Apr 2002
    Location
    Minnesota
    Posts
    821
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Create your toolbar and save it in a separate workbook.

    Then at the user's pc, attach your toolbar to their personal.xls file.

  7. #7
    Board Regular Jak's Avatar
    Join Date
    Apr 2002
    Location
    Newcastle upon Tyne
    Posts
    796
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks guys for all your insight. I think I will go for the add-ins methodology to solve the problem.

  8. #8
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Also take a look at the Menumakr download on Chip Pearson's site, should do most of what you want to do.

  9. #9
    Board Regular Jak's Avatar
    Join Date
    Apr 2002
    Location
    Newcastle upon Tyne
    Posts
    796
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Mudface

    have you got the address for Chip Pearsons site?

  10. #10
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Sorry, it's actuallly John Walkenbach's web site:-

    http://j-walk.com/ss/excel/tips/tip53.htm

    Chip Pearson's page is very good too:

    http://www.cpearson.com/excel.htm

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com