macro/fileanme help
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?
|