Mighty QuinnConsultingMighty Quinn Consulting — home

Signed, or it doesn't run

Suspicious code stops here, not in production

Category
Custom Built, complexity tier 3 of 3
Status
Live
central inventory of every macro in the company
1
Stack
  • Power Automate
  • Power BI
  • SharePoint Online
  • Outlook

The problem

VBA macros in Office files are a real productivity tool and a real attack surface at the same time — and nobody in the company knows who is using what, where, or what for. Blocking them outright breaks legitimate workflows; allowing them unchecked is a standing security risk. Somehow, file by file, somebody has to decide whether a macro is safe — and that decision has to be consistent, auditable, and as efficient as it can be made.

What it does

Employees upload Office files containing VBA macros to a self-service portal. The service extracts every macro module and analyses it both statically and dynamically — simulation and sandboxing — for suspicious constructs. Unproblematic files are signed automatically; flagged ones can go to a manual review before signing, or simply raise a warning. The process is configurable.

Together with a correspondingly configured Office policy, only signed macros run. The path from upload to trusted, executable code is consistent and traceable end to end. And as a side effect you get a central inventory of every macro file in the company — with a clear record of who has them in use, where, and what for.

Where it runs

On Azure, GCP or on-premise — operated by us or by you.

The signing key stays with you: secured inside the solution itself, or in a Key Vault in your own Azure environment. Uploaded files never leave your environment, and the service needs no outbound connection. Even when we run it, neither the key nor a single file sits outside.

One part is deliberately outside the service. For only signed macros to run on your clients in the end, the certificate has to be distributed as a Trusted Publisher — together with the Office policy above. The service creates the trust; enforcing it happens in endpoint management.

More Custom Built

Custom Built, complexity tier 3 of 3

crimSun

An integrated, sovereign collaboration suite for on-premise and air-gapped operation: files, messages, mail, calendar and meetings inside a single, auditable trust boundary.

6modules in one product

  • Go
  • PostgreSQL
  • Keycloak
  • Collabora
  • +4