DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Tutorial for Controlbars / Menus ?

  1. #1
    Jürgen Schoch Guest

    Tutorial for Controlbars / Menus ?


    Hi everybody,
    I created an Excel Add-In (which is loaded correctly ) but cannot access
    the macro in there via Tools/Macros.
    I guess I have to create an entry in the menu from within the Add-In to run
    this macro? For this reason it would be nice to have a tutorial, because
    I failed in creating this entry. Or is there an other way to access the macro?

    Thanks

    Jürgen Schoch

  2. #2
    Antti Guest

    Re: Tutorial for Controlbars / Menus ?


    Macros stored in an Excel Add-In (xla) don't show in list of macros in Tools/Macros
    (at least in Excel 97). You can however run them by simply typing the name
    of the macro in the "Macro name" -textbox. Once you have typed a macro name
    that exists the Run button is enabled.

    Antti

    "Jürgen Schoch" <schoch@gsf.de> wrote:
    >
    >Hi everybody,
    >I created an Excel Add-In (which is loaded correctly ) but cannot access
    >the macro in there via Tools/Macros.
    >I guess I have to create an entry in the menu from within the Add-In to

    run
    >this macro? For this reason it would be nice to have a tutorial, because
    >I failed in creating this entry. Or is there an other way to access the

    macro?
    >
    >Thanks
    >
    >Jürgen Schoch



  3. #3
    Jonathan Martens Guest

    Re: Tutorial for Controlbars / Menus ?


    Hi Jürgen,

    Take a look here:

    http://msdn.microsoft.com/library/en...asp?frame=true

    It's a page form Microsofts Developer Network (MSDN). You can find a lot
    here.

    Good luck!

    Jonathan

    "Antti" <antti.komonen@hotmail.com> wrote:
    >
    >Macros stored in an Excel Add-In (xla) don't show in list of macros in Tools/Macros
    >(at least in Excel 97). You can however run them by simply typing the name
    >of the macro in the "Macro name" -textbox. Once you have typed a macro name
    >that exists the Run button is enabled.
    >
    >Antti
    >
    >"Jürgen Schoch" <schoch@gsf.de> wrote:
    >>
    >>Hi everybody,
    >>I created an Excel Add-In (which is loaded correctly ) but cannot access
    >>the macro in there via Tools/Macros.
    >>I guess I have to create an entry in the menu from within the Add-In to

    >run
    >>this macro? For this reason it would be nice to have a tutorial, because
    >>I failed in creating this entry. Or is there an other way to access the

    >macro?
    >>
    >>Thanks
    >>
    >>Jürgen Schoch

    >



  4. #4
    Jürgen Schoch Guest

    Re: Tutorial for Controlbars / Menus ?


    Hi Jonathan,
    thanks, now I succeeded.


    "Jonathan Martens" <j.martens@student.utwente.nl> wrote:
    >
    >Hi Jürgen,
    >
    >Take a look here:
    >
    >http://msdn.microsoft.com/library/en...asp?frame=true
    >
    >It's a page form Microsofts Developer Network (MSDN). You can find a lot
    >here.
    >
    >Good luck!
    >
    >Jonathan
    >
    >"Antti" <antti.komonen@hotmail.com> wrote:
    >>
    >>Macros stored in an Excel Add-In (xla) don't show in list of macros in

    Tools/Macros
    >>(at least in Excel 97). You can however run them by simply typing the name
    >>of the macro in the "Macro name" -textbox. Once you have typed a macro

    name
    >>that exists the Run button is enabled.
    >>
    >>Antti
    >>
    >>"Jürgen Schoch" <schoch@gsf.de> wrote:
    >>>
    >>>Hi everybody,
    >>>I created an Excel Add-In (which is loaded correctly ) but cannot access
    >>>the macro in there via Tools/Macros.
    >>>I guess I have to create an entry in the menu from within the Add-In to

    >>run
    >>>this macro? For this reason it would be nice to have a tutorial, because
    >>>I failed in creating this entry. Or is there an other way to access the

    >>macro?
    >>>
    >>>Thanks
    >>>
    >>>Jürgen Schoch

    >>

    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center