Excel file with VBA code - ERROR

[CHofm]

Hello everyone,

I´ve got a problem with my excel file. There are 2 VBA codes included. Whenever I start the file by double klicking the file on the desktop, the following error occurs.

It says, that they repaired and removed the VBA code.

In fact, my macros don´t work anymore and I have no further acces to VBA.

Whenever I start a blank Excel file and then open the needed file, everything works just fine.

Anyone who have an idea about this problem?

Thanks in advance guys.

[#2]

Are you able to share the file in question? Please remove sensitive information first.

[#3]

@Jan Karel Pieterse : thanks for your reply.

I´ve uploaded a Test-file with an empty macro. It doesn´t matter wheter there is a macro-code. Even if VBA is empty at all - there is always the same error. I think there might be some problems with excel or windows since I can open the excel file in the way I´ve already mentioned: Open an empty Excel file and then search for the needed file. That´s the weird stuff.

[#4]

FOund this, perhaps it gives you some pointers?

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_2010/removed-part-xl...
and
https://stackoverflow.com/questions/5124184/how-do-i-recover-this-vba-project-excel-error-message-re...