All,

I have a workbook in which I've created buttons on the worksheet and
assigned macros to each. The macros are linked to another wb which I
have hidden and auto-startup when Excel opens. The purpose of this is,
when done, I will have 50+ documents that will need to use the same
macros on 40+ different computers. When future changes are made to the
macros (printer names, etc.), I do not want to have to change all 50+
documents. My plan is make the auto-starup doc available on the network
with a BAT file to automatically copy over the existing one on each
computer.

Problem I am having is the button on the worksheet loses it's link to
macro wb on the other computers. I have to re-assign the macro on all
40+ computers. Is there a way when I assign the macro to the button
for it *not* to store a "path" and only look for the hidden macro wb?

Currently, the error I get is... "A document with the name
"nsf_macros.xls" is already open. ..."

I appreciate any and all help with this.

Matt