Trouble playing back macros after copying a spreadsheet

[Christopher]

I've been developing a few macros to go along with a
spreadsheet that I have. The macros work great on my PC
but when I copy the spreadsheet to a network location and
try to open the spreadsheet from there, I get the
following error message "A document with the same name is
already open..." I only have the one spreadsheet open so
ca?n someone tell me what's going on?

In addition, when someone else opens the same
spreadsheet, they're told that the macros can't be found;
again, what's going on?

Thx in advance,
Christopher

 

[Dave Peterson]

It sounds like you used a filename that that other person was using already.

One common name is personal.xls. If you're going to share with others, don't
use this name. Many already have their very own favorite macros in a file
called this.

How do you get that second error? Did you click on an icon on a toolbar that
runs your code?

If yes, then how did you build that toolbar? Did you attach it to your
workbook?

If yes, then you'll want to read Jan Karel Pieterse's notes:
http://google.com/[email protected]

If none of this is close, post back with some more details.