Sure, the validators that were checking his work could easily be canned. Mr VBA-Wizard, however, might be put to work doing other "magic" in the organization.
The OP already addressed this: "This isn’t like a company with tons of IT work - they have a legacy system where they keep all their customer data since forever, and they just need someone to maintain it." The OP believes that there won't be other work for him if his current job becomes unnecessary.
