Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Australia
    Posts
    1,294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    how do I add a button & code to excel menu?

    HIya - I code in word & am just beginning to code in excel.
    I've have code & modules in an excel template.
    In excel in the menu >File
    I would like to add a button & my code behind this button.

    In ms-word I would goto Tools>Customise>Commands>Macros - displays a list of code >than I would find my code than drag onto the desired location.

    However when I do the same in excel - when I click on Macros - no code is displayed.

    Is it a different process in excel to create a button & have custom code behind the button.
    Please explain how I can do this?
    tia - regards Diana

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: how do I add a button & code to excel menu?

    Office is great for consistency. In Excel, the order of things is a bit different from Word:
    <UL><LI>Select Tools/Customize
    <LI>Click on Command tab
    <LI>In Categories, select Macros
    <LI>Drag the item named Custom button to the desired tool bar
    <LI>Right click the new button on the tool bar and select Assign macro
    <LI>Now you can choose one of the macros you wrote and click OK.[/list]The other customizations (button face etc.) are more or less the same as in Word.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Australia
    Posts
    1,294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how do I add a button & code to excel menu?

    Hans - thanks that worked!- Diana

Posting Permissions

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