Mighty QuinnConsultingMighty Quinn Consulting — home
Consulting

Retail · Information Security

Macro Signing Rollout

A global rollout of the rule that only signed Office macros may run — together with the portal that checks and signs them.

Duration
< 12 months
Budget
100.000 €
Project team
MQC 2 · Client 4

End-of-project survey

Overall satisfaction10/10
Budget9/10
Time8/10
Quality10/10
Collaboration9/10

Every project ends with the same questionnaire: five answers from 0 to 10, in the spirit of a Net Promoter Score. We publish what comes back, including when nothing does.

The brief

  • Make sure only VBA macros that have been checked and signed with a trusted certificate can run in Microsoft Office
  • Establish the policies and the processes for reviewing macros and approving them, manually and automatically

The build

  • Designing and testing the relevant Office policies and what they do
  • A central signing portal for uploading macro files to be checked and signed automatically
  • A two-stage rollout: first an Office add-in that warns when an unsigned macro is used, then the Office policies themselves
  • An escalation route for business-critical macros, including outside normal working hours
Tech stack
  • Microsoft 365 Cloud Policies
  • VSTO Add-In for Office
  • TypeScript
  • Go
  • STACKIT
Our part
  • Project Management
  • Rollout Management
  • Communication and Change Management
  • Conception
  • Development

The good

  • Internal "fairs" and events about the subject during the rollout were taken up extremely well
  • Genuinely good exchange and cooperation with the local information security officers

The bad

  • Detecting unsigned macros reliably in the Office add-in took several rounds of testing
  • Getting the rollout communication to reach every affected end user was a challenge