Excel VBA Too Large

I am writing (and continually updating) a rather large application using Excel and VBA. I recently added some code and I can no longer save the file. The program does what I want if I don't try to save it. Once I attempt a save, Excel locks up and terminates without a successful save. I am using Excel 2000. I see that many things have been expanded with later version of Excel but would like to stay with what I have. I have tried to save this file on two different computers without success. I ran into this before but was able to trim my code so that it would compile. I was not very space conscious when writing this code and I am sure I can reduce things but am not sure what is the best way to track things throughout the program.
I am looking for a couple of things.
1. Is there any type of a cross-reference file producing program short of writing one myself in VB or something like that? I want to look at where variables are used in the program hopefully by line number - this would be like an old days COBOL (and other) compile listing. I have saved the VBA Code as a text file so that I can manipulate it in most any way necessary.
2. I am using an external Excel form as part of the application. Can I write VBA Code in this workbook as well? And if so, how do I reference code that is placed there?

What is the error message you get? Maybe you could google it.

According to this link, maybe one of your procedures is too big, so split it into more smaller ones?
http://msdn.microsoft.com/en-us/libr.../gg251481.aspx

Originally Posted by RHCPgergo

What is the error message you get? Maybe you could google it.

According to this link, maybe one of your procedures is too big, so split it into more smaller ones?
http://msdn.microsoft.com/en-us/libr.../gg251481.aspx

=======
I do not actually receive an error - I just receive the "Program is not responding ..." message. Once I quit, I need to reboot Windows in order to free up the Excel background update file. I believe it also leaves a file that is something like A79826 or B0970 or something that begins with a letter and ends with several numbers, without an extension. At times, I can add the .xls extension and then open one of these files with Excel. I can duplicate the problem any time and be more specific if that would help.