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

Might want to use an addin that creates a menu when it is loaded and deletes
it when it closes. Have the users load the addin from the network:

See Jan Karel Pieterse's tutorial at:

http://www.jkp-ads.com/Articles/DistributeMacro00.htm

http://support.microsoft.com/?id=167909
XL: Securing Visual Basic Code in Microsoft Excel

http://support.microsoft.com/?id=156942
XL97: How to Create an Add-in File in Microsoft Excel 97

http://support.microsoft.com/?id=211563
How to create an add-in file in Excel 2000

http://msdn.microsoft.com/library/en...xceladdins.asp

http://msdn.microsoft.com/library/en...exceladdin.asp

http://www.j-walk.com/ss/excel/tips/tip45.htm
Excel 97: Creating Add-Ins

Some of the above links may not work, but some should.

Here is an article about creating commandbars with code:
http://msdn.microsoft.com/library/en...ce04042002.asp

--
Regards,
Tom Ogilvy




"MattW" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>