I've been in the VB code of the macros, but there is no path called out
anywhere that I can see.

To get the toolbar macros to work, I had to set the buttons up again
(because of the path issue).

"pa_broon74" wrote:

Hey.

I wouldn't mind knowing about this too, I did the same as you. Three
buttons with three corresponding macros, all they're doing on the
other computers is trying to open the spreadsheet containing the
macros and since it is already contained within the XLstart folder its
already open...

As to your problem, open up the VB editor (Tools - Macros [highlight
the macro you wish to change] - Edit) and find the line in the VB
script that tells it where the external file is and change it to the
new file path on the other user's PC. As long as you keep the same
syntax it should work ok.

Remember to keep a back up of the macro incase you make a mistake, (If
you do make a mistake the editor highlights the line of script in
yellow...)

Hope this is helpful, if any one can tell me why my macros aren't
running properly it would certainly save a PC being lobbed out off a
window :-)

Cheers.