Is there any way to get an event when a workbook or a worksheet is renamed in an Excel-DNA based addin? Apparently, the Application object doesn't expose these events directly.
There is no API way, but there are quite a few workarounds.
Maybe this will help: