I have an add-in called BkColl.xla. It has three macros in a module. It also
has a custom toolbar called tbarBk. It has three buttons -- and the macros
attached to them are called mcrSpecSum, mcrSpecAvg and mcrClrGridLine.

In Excel, I have gone to TOOLS | Add-ins and added the tbarBk add-in there.

How will I be able to see the custom toolbar and macrobuttons in any
worksheet that I open?

Also six people have to share this add-in. Can all of them access the same
file if they turn on this particular add-in from a shared folder?

Thanks for your help.