can share vba script using different workbook?
 

i develope a vba script and put in commandbutton toolbar. my problem
is each of the user is using their own workbook. they do not want to
share the same workbook in the server. may i know
1)i need to put in my macro in each of user's workbook?
2)any good way so that even they use their own workbook but still can
execute my macro.

thanks alot