Fixing Run-time Error 91 in Excel VBA

If you’ve run into “Run-time error ’91’: Object variable or With block variable not set” in Excel VBA, you’re not alone. This error is one of the most common VBA issues—and while it often relates to object variables not being initialized, there’s another sneaky cause many people miss.

✅ The Hidden Fix: Trust Center Setting

Sometimes, the problem isn’t in your code at all—it’s Excel blocking your code from accessing the VBA project environment.

✅ Here’s how to fix it:

1. Open Excel.
2. Go to File > Options.
3. Click on Trust Center in the left menu.
4. Click Trust Center Settings.
5. Go to Macro Settings.
6. Check the box that says: ✅ Trust access to the VBA project object model
7. Click OK, then OK again to close the dialogs.