can you provide more information as to where you see the
workbook name or the pathname in the workbook.

Check --- Tools, Options, General (tab)
Default file location: (should be on user's drive)
and is used for saving new files.

"Daniel R" ...
I have a spreadsheet that is saved on a network drive and contains macros.
It is saved under a "general" file name. When people use it, they are going
to open it and resave in on their personal c drive under a different name.
However, when they do this, it causes an error in the macro's since they seem
to contain the original Excell file name in the programing. I did not
purposefully put the file name into the programinng, but it's there non the
less.

How do I fix this?