I have a question regarding, I think, the storage location of Macros.

I have a template used for quote generation stored on a network drive. The
template has a toolbar which calls various macros. When anyone loads the
template and then clicks on the toolbar it calls either 1. Calls a macro in a
different worksheet or 2) Asks for a macro to run.

I have tried various combinations of linking the icon on the toolbar to a
macro in:
1) All Open workbooks
2) This workbook
3) New Quote Sheet.xls

All with varying degrees of unsuccess.

We need to keep the template on the network drive so any changes made to it
are reflected. So I don't have to change the template in 6 different
workstations.

Thanks for your help.