Check out Rob Bovery's Code Cleaner, which does all those things -
automated! If it crahses, clean the workbook with macros disabled.
www.appspro.com
Alex J
"Felix" wrote in message
...
I have had that problem before. I found two solutions.
1. Export all your code. Import the code to a new
Workbook. Copy information in your sheets to the new
workbook. Sometimes it works to use the move/copy sheet
function (saves some time) but not always.
2. A lot easier but it will cost a little. There is a
utility called Excel Workbook Rebuilder (find it at
VBUser.com) that will rebuild your Workbook from scratch
and should fix the problem you are seeing.
Hope this helps,
Felix
-----Original Message-----
Hi,
I have a workbook that i am automating. After about a
year of this i
have had to make a few more updates but i have a problem.
Everytime i
try to create a new procedure
for example i just type in:
sub NewProcedure()
i get an error message that excel has created an erorr
and will be shut
down.
I can do everything else, i can run all the other
procedures and
everything but i can't add any more in.
I am using excel 2000 but when i try this on excel xp or
2003 it does
the same thing
i have tried to repair the file but that doesn't seam to
work either. I
just think this is very weird. has anyone else had this
problem?
i might just have to create a new workbook :(
cheers
stu
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/
~~Now Available: Financial Statements.xls, a step by step
guide to creating financial statements
.