Add icon to toolbar

I want to (as part of my XLA addin in he XLStart folder) have an icon
appear automatically on the toolbar to run a function within that
project.

I am hoping to be able to present a single xla file to be copied in the
xlstart folder, that will basically keep the end users from doing
anything other then clicking on the icon it creates.

Any other information/suggestions/comments (outside the specific
question) is also very welcome.

just have the Workbook_Open event add a temporary button to the appropriate
toolbar.

http://support.microsoft.com/?id=159619
XL97: Sample Macros for Customizing Menus and Submenus

http://support.microsoft.com/?id=213550
XL2000: Sample Macros for Customizing Menus and Submenus

--
Regards,
Tom Ogilvy


"Robert.Cordani@us.schneider-electric.com" wrote:

> I want to (as part of my XLA addin in he XLStart folder) have an icon
> appear automatically on the toolbar to run a function within that
> project.
>
> I am hoping to be able to present a single xla file to be copied in the
> xlstart folder, that will basically keep the end users from doing
> anything other then clicking on the icon it creates.
>
> Any other information/suggestions/comments (outside the specific
> question) is also very welcome.
>
>

>From what I have read, I figured it was along those lines, but not sure
how to go about it. I have only been using VB for about 4 weeks now.

I have tried making a workbook_open event, which led me into class
modules... but I am not getting something right. Even the link you
posted, is very vaque (or I am simply to dumb) about the full process.
Any information (particularly examples) would be appreciated.

Tom Ogilvy wrote:
> just have the Workbook_Open event add a temporary button to the appropriate
> toolbar.
>
> http://support.microsoft.com/?id=159619
> XL97: Sample Macros for Customizing Menus and Submenus
>
> http://support.microsoft.com/?id=213550
> XL2000: Sample Macros for Customizing Menus and Submenus
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Robert.Cordani@us.schneider-electric.com" wrote:
>
> > I want to (as part of my XLA addin in he XLStart folder) have an icon
> > appear automatically on the toolbar to run a function within that
> > project.
> >
> > I am hoping to be able to present a single xla file to be copied in the
> > xlstart folder, that will basically keep the end users from doing
> > anything other then clicking on the icon it creates.
> >
> > Any other information/suggestions/comments (outside the specific
> > question) is also very welcome.
> >
> >

>From what I have read, I figured it was along those lines, but not sure
how to go about it. I have only been using VB for about 4 weeks now.

I have tried making a workbook_open event, which led me into class
modules... but I am not getting something right. Even the link you
posted, is very vaque (or I am simply to dumb) about the full process.
Any information (particularly examples) would be appreciated.

Tom Ogilvy wrote:
> just have the Workbook_Open event add a temporary button to the appropriate
> toolbar.
>
> http://support.microsoft.com/?id=159619
> XL97: Sample Macros for Customizing Menus and Submenus
>
> http://support.microsoft.com/?id=213550
> XL2000: Sample Macros for Customizing Menus and Submenus
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Robert.Cordani@us.schneider-electric.com" wrote:
>
> > I want to (as part of my XLA addin in he XLStart folder) have an icon
> > appear automatically on the toolbar to run a function within that
> > project.
> >
> > I am hoping to be able to present a single xla file to be copied in the
> > xlstart folder, that will basically keep the end users from doing
> > anything other then clicking on the icon it creates.
> >
> > Any other information/suggestions/comments (outside the specific
> > question) is also very welcome.
> >
> >

http://msdn.microsoft.com/library/de...ce04042002.asp

--
Regards,
Tom Ogilvy

<Robert.Cordani@us.schneider-electric.com> wrote in message
news:1154369882.542917.275580@i42g2000cwa.googlegroups.com...
> >From what I have read, I figured it was along those lines, but not sure
> how to go about it. I have only been using VB for about 4 weeks now.
>
> I have tried making a workbook_open event, which led me into class
> modules... but I am not getting something right. Even the link you
> posted, is very vaque (or I am simply to dumb) about the full process.
> Any information (particularly examples) would be appreciated.
>
> Tom Ogilvy wrote:
>> just have the Workbook_Open event add a temporary button to the
>> appropriate
>> toolbar.
>>
>> http://support.microsoft.com/?id=159619
>> XL97: Sample Macros for Customizing Menus and Submenus
>>
>> http://support.microsoft.com/?id=213550
>> XL2000: Sample Macros for Customizing Menus and Submenus
>>
>> --
>> Regards,
>> Tom Ogilvy
>>
>>
>> "Robert.Cordani@us.schneider-electric.com" wrote:
>>
>> > I want to (as part of my XLA addin in he XLStart folder) have an icon
>> > appear automatically on the toolbar to run a function within that
>> > project.
>> >
>> > I am hoping to be able to present a single xla file to be copied in the
>> > xlstart folder, that will basically keep the end users from doing
>> > anything other then clicking on the icon it creates.
>> >
>> > Any other information/suggestions/comments (outside the specific
>> > question) is also very welcome.
>> >
>> >
>