Macro question

[Guest]

I have developed a small number of macros and they work great when I use them from within the spreadsheet on my laptop. For some reason, when I copy the spreadsheet to a network location and open the spreadsheet from there, I get the error message "A document with the name <...> is already open." I don't understand why I'm getting this message as there are no other documents open

Another question, when someone else opens up the same spreadsheet from the network (or the copy that I email to them), they get a message tat basically says that the macros couldn't be found; I have Office XP and they have Office 2000

Any help is appreciated.

 

[Earl Kiosterud]

auutumn,

Step through your macro (F8) to see which line is causing the error. Let
us know

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

I have developed a small number of macros and they work great when I use

them from within the spreadsheet on my laptop. For some reason, when I copy
the spreadsheet to a network location and open the spreadsheet from there, I
get the error message "A document with the name <...> is already open." I
don't understand why I'm getting this message as there are no other
documents open.

Another question, when someone else opens up the same spreadsheet from the

network (or the copy that I email to them), they get a message tat basically
says that the macros couldn't be found; I have Office XP and they have
Office 2000.