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