Excel continues to stop

Experts,
Every time I try to rename a tab in my workbook, Excel stops and trys to recover my workbook. The error log generated to restore the program is below, which I have tried to interpret. This is a reoccurring problem, but does not appear if I copy sheets from one workbook to another. I've tried numerous Excel fix suggestions that are temporary or do not locate the problem. The problem is unique to the workbook since it follows me regardless of what machine I am using. The log does identify two removed features but I cannot seem connect with them.

<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error076760_01.xml</logFileName>
<summary>Errors were detected in file 'G:\Excel\Excel Formulas and Functions.xlsm'
</summary>-<removedFeatures summary="Following is a list of removed features:"><removedFeature>Removed Feature: Object from /xl/workbook.xml part (Workbook)</removedFeature><removedFeature>
Removed Feature: OLE Control Extension from /xl/workbook.xml part (Workbook)</removedFeature>
</removedFeatures></recoveryLog>

I would really like to know what is wrong with this workbook (attached). Thanks for helping
Excel-Formulas-and-Functions.xlsm
Frank FreeseAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MacroShadowCommented:
Must be something with the first sheet, delete it and renaming won't cause a crash. I don't have time now but when I do I'll look into it.
0
Frank FreeseAuthor Commented:
Thanks - just a thought but it may have something to do with the code in one of the list boxes or when the workbook loads.
0
MacroShadowCommented:
Private Sub lstCategory_Click() is the culprit. You have a simple typo, change all occurrences of
illRange = ""
to
lstTopic.ListFillRange = ""
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Frank FreeseAuthor Commented:
I think you got it - the numbers of hours I've spent and I could not see the problem.
Hopefully, problem resolved.
Thank you kindly
0
Frank FreeseAuthor Commented:
Thank you so very much
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.