Microsoft like AutoCAD allows VBA to be enabled because so many old VBA users still can't let go but both recommend against it.
In Excel this option is Enable VBA macros (not recommended, potentially dangerous code can run) and it only applies to VBA macros.
True there are many that ignore these warning and enable VBA code anyway. As long as you work in a closed shop, stay offline and don't exchange files outside your office you're probably fine.