How to remove xla from xls without renaming or deleting xla file?

Question

I need to get rid of an XLA (excel add-in) from a spreadsheet, but everything on the web seems to point to renaming/deleting the xla file.

This is not an option as the xla file is used by many other spreadsheets and is on a shared drive.

Are there any other alternatives?

Answer 1

I copied all the classes and modules (drag and drop) from the xla to the 'local' project.

Save and close xls

I searched for the xla project name in the registry (with excel closed) and deleted the value.

Open excel

Done