The macro may not be available in this workbook or all macros may be disabled even after modified trust center

[Random.Username]

after a few hours of having this problem and searching the forums, this was the solution that helped me. Thanks for sharing!