To test this situation I made a copy of a 'File1' and saved it as 'File2', where File1 had many macros that ran within the file (none required the use of any other files). The problem comes when I open File1 and File2 and then close File2.
Then when I try to run a macro in File1 it just opens File2 even though I did not copy anything from File2 into File1 or make any changes whatsoever.
This was an experiment I tried to do to narrow the problem, as of now I know its not because of copied text. This problem arrived when I tried to copy information from a different file into 'File1' and when I closed the other file, and tried to run a macro in File1, it would open the old file I copied from.
Also, I found that to fix this problem I had to close both files and reopen them. However the macro file is quite large and takes time to save changes in and it can get frustrating when you are required to close everything after a simple copy and paste operation, just to get it to work.
Can someone help me with this as it is crucial to the project im working on.