How to Fix Run Time Error 1004, Cannot Run the Macro in Microsoft Excel (2026 Guide)
Hey friends, in today's short video I will show you exactly how to fix the annoying "Run Time Error 1004: Cannot run the macro" message in Microsoft Excel. This common error usually pops up when Excel is blocking your VBA scripts due to security settings, or when your macro is trying to reference a worksheet or range that doesn't exist.
First, let's fix the Trust Center settings: click the "File" tab in the top left, go to "Options," and select "Trust Center". Click the "Trust Center Settings" button, navigate to the "Macro Settings" tab, and make sure you select "Enable all macros" (for trusted files) and also check the box that says "Trust access to the VBA project object model" before hitting "OK". If that doesn't fix it, press ALT + F8 to check if your macro name is spelled correctly and still exists, or press ALT + F11 to debug your VBA code and ensure it isn't referencing deleted sheets or invalid cell ranges.
For business inquiries, hit me up on: [email protected]