The other posters talked about creating a toolbar in code, very
powerful, but maybe too much.

Simple solution:

Save your XLS as addin (XLA)
Create a new toolbar.
Set your Addin property for your XLA to false(VBE select XLA workbook
and see proporties window).
Add Macro to toolbar(should now be visible).
Select XLA workbook in Excel
Attach your Toolbar to XLA
Sett Isaddin = True

In XLA Workbook close event

Commandbars("Mycommandbar").Delete

This should work without coding anything extra.

DM Unseen