Consulting

Results 1 to 5 of 5

Thread: Solved: Create Custom Menu Macro Items in Excel VBA

  1. #1
    VBAX Contributor
    Joined
    May 2008
    Posts
    109
    Location

    Solved: Create Custom Menu Macro Items in Excel VBA

    Pls, someone can help me to create a custom Macro items. I have a lot of macro and everytime I have to do a lot of work (open windows, close windows an so on) to run my macro.
    Thanks

    sasa

  2. #2
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    What version of Excel?
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  3. #3
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Quote Originally Posted by sasa
    Pls, someone can help me to create a custom Macro items. I have a lot of macro and everytime I have to do a lot of work (open windows, close windows an so on) to run my macro.
    Why, what do the macros do?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  4. #4
    VBAX Contributor
    Joined
    May 2008
    Posts
    109
    Location
    Excel 2007. What I need is a customizable menu where I can add the items of my macros, the way I can run these from there. Thats all. Can someone help me ?

  5. #5
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Show the Developer tab, Office Button>Excel Options>Popular and tick the 'Show Developer Tab in the Ribbon', which has buttons to ru macros amongst other things.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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