Macro question

A

auutumn

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.
 
E

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
-------------------------------------------

auutumn said:
I have developed a small number of macros and they work great when I use
Click to expand...
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
Click to expand...
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.
 
Top