Creating a toolbar

[William Francis]

Hi folks,

I am building a toolbar to be used by staff in my office to automate certain
Excel functions.

I am looking to build a sheet which I will send to the staff, which they
will open once and this will load the toolbar into their Excel and save the
toolbar, meaning that it should appear whenever they open Excel from now on.

The problem I am having is that I cannot create a menu option at the top of
the Excel page (what I want is for a menu item to be created at the top named
'Toolbar', when they click this the toolbar loads into Excel).

This menu works fine for me just now, however I cannot create this using VBA
so that I can send a sheet to every team member to create the toolbar?

Any thoughts?

Any help appreciated.

Will

[Robin Hammond]

Will,

To achieve what you are looking for in your suggested way would mean
altering each user's own toolbar, which they may well have customised
already. It's not really a good idea.

You would be much better off putting your toolbar inside an add-in, which
could then be loaded permanently or on demand by your users. The add-in
could also create menu entries if you wish.

John Walkenbach has some code posted that shows how to do this on the fly,
which appears to be the most reliable method on www.j-walk.com somewhere.

Robin Hammond
www.enhanceddatasystems.com

"William Francis" <[email protected]> wrote in
message news:[email protected]...
> Hi folks,
>
> I am building a toolbar to be used by staff in my office to automate
> certain
> Excel functions.
>
> I am looking to build a sheet which I will send to the staff, which they
> will open once and this will load the toolbar into their Excel and save
> the
> toolbar, meaning that it should appear whenever they open Excel from now
> on.
>
> The problem I am having is that I cannot create a menu option at the top
> of
> the Excel page (what I want is for a menu item to be created at the top
> named
> 'Toolbar', when they click this the toolbar loads into Excel).
>
> This menu works fine for me just now, however I cannot create this using
> VBA
> so that I can send a sheet to every team member to create the toolbar?
>
> Any thoughts?
>
> Any help appreciated.
>
> Will