Is it worth learning VBA in 2026, or should I shift to Office Scripts? (Confused about my workplace dynamic)

Hey everyone,

I'm currently facing a bit of a dilemma regarding what to learn next to automate my Excel workflows, and I could really use some advice based on my workplace situation.

My Situation:

• My Team: We mostly use standard Excel with formulas. The team is very comfortable with formula-based sheets and prefers keeping things simple.
• My General Manager (GM): On the other hand, my GM heavily uses VBA for macros and automation.

Given that it's 2026, I know Microsoft is pushing Office Scripts (TypeScript) for cloud/web compatibility, but my immediate boss (GM) is still all about VBA.

Should I spend time mastering VBA just to align with my GM, or should I invest my time in Office Scripts/Power Query since they are more future-proof? What would be the smartest move here?

Thanks in advance!