In addition to this approach, which IMO is much better than attaching a toolbar you should make
sure the .OnAction property of the buttons includes the workbook name as a prefix to the
procedure to be run. This is how I do this:

.OnAction = ThisWorkbook.Name & "!ProcedureToRun"

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

bdcrisp wrote:

What has worked for me is creating a custom add-in that includes the
custom menu creation on open , deletion on exit. Have you tried this
avenue?