MicrosoftI recently found out that in one Excel file of mine after a crash, re-build as xlsb and save again as xlsm file, my macros were "detached" from my form buttons in my worksheet. The macros themselves were running fine, but in no way could I create a macro and attach it to a form button. Even adding a new button and connecting it to a basic "helloworld" macro fails with the error message "The macro may not be available in this workbook or all macros may be disabled".
I've posted it a bit more extensive here: https://www.reddit.com/r/vba/comments/r1abrx/macro_detaching_from_form_button/
Through a SO post (https://stackoverflow.com/questions/69890212/running-excel-macro-using-button-not-working ) I found this macro 4.0 setting. On switching it on and re-opening the file the buttons worked as before. However: I assume that is not what that security feature is meant for - AFAIK the buttons & VBA macros I'm using are not 4.0? Auston
