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
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