Workbook crashes after renaming a worksheet - References problem?
 

My application consists of a workbook with an installed Addin. I made a
Reference to the Addin project because I needed to use/access an UDF
stored in the Addin. So far so good, the function gives the expected
result.

My workbook has 2 sheets. One sheet with the UDF, and 1 without. If I
manually rename the worksheet without the UDF (from the Tab at the
bottom) nothing happens. But if I do the same with the one storing the
UDF, Excel crashes time and again.

I have done the following to investigate:
* Used Rob Bovey's Code Cleaner 4.4 to clean both the workbook and the
Addin = No effect.
* Used Excel in safe mode = still crashing.
* Removed the reference to the Addin = no more problem, I can rename
without getting the workbook crashed. But now the UDF does not work
anymore of course!

I don't get it!

Dilemma:
I need the reference to get the UDF working (and would prefer to keep it
stored in the Addin), but can not rule out that the user renames the
worksheet.

Anyone who can explain to me what is happening here?

Best regards,

Bennie Douma

Excel XP / Windows XP Home Edition

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!