Excel VBA Close Workbook Without Saving: Force Quit Without Prompt

I lost hours to Excel’s “save changes” popups before discovering this VBA trick. One line of code closes any workbook instantly without prompts or saves.

This isn’t just about convenience—it’s a lifesaver when automating reports that generate temporary files. The command bypasses Excel’s safety checks, so use it carefully in production scripts.

You’ll need basic VBA access and a clear understanding of which files you want to discard. The syntax is shockingly simple: just specify the workbook and add the close method with the right parameter.

Works across all modern Excel versions. Here’s how to implement it safely.

What Youll Need

Step-by-Step Instructions for Closing a Workbook Without Saving in Excel VBA

Here’s the method I use to ensure workbooks close silently without any save prompts.

Press Alt + F11 to open the VBA editor. This is where all macros and custom functions live. I always verify the Project Explorer pane is visible on the left—if not, go to View > Project Explorer.

Right-click on the workbook name in the Project Explorer, select Insert > Module. This creates a new container for your code. The editor will open a blank code window ready for your macro.

In the module window, type the following code exactly as shown: Sub CloseWithoutSaving() on the first line, then press Enter. On the next line, type ThisWorkbook.Close SaveChanges:=False. This is the critical line that forces the workbook to close without saving.

The SaveChanges:=False parameter explicitly tells Excel to discard any changes. Without this, Excel defaults to prompting the user, which defeats the purpose of automation.

Close the VBA editor and return to your workbook. Press Alt + F8 to open the Macro dialog. Select CloseWithoutSaving from the list and click Run. The workbook will close immediately without any prompts.

If you get a security warning, you may need to enable macros. Go to File > Options > Trust Center > Trust Center Settings > Macro Settings and select Enable all macros (temporarily for testing).

To make this even more convenient, add a button to your Quick Access Toolbar. Go to File > Options > Quick Access Toolbar. From the Choose commands from dropdown, select Macros.

Select your CloseWithoutSaving macro, click Add, then OK. Now you have a one-click button to close the workbook without saving. The button appears in the top-left corner of the Excel window.

Test with an unsaved workbook containing changes. The macro should close it instantly. If the workbook contains unsaved changes from other users in a shared environment, the macro will still close without saving—be absolutely certain this is the intended behavior.

For workbooks with BeforeClose event handlers that might interfere, add Application.EnableEvents = False at the start of your macro and Application.EnableEvents = True at the end to prevent unexpected triggers.

Tips and Common Mistakes

These insights will help you avoid pitfalls and get the most out of your automation.

Critical Parameter: In Step 2, the SaveChanges:=False parameter is non-negotiable. This single line is what prevents Excel from showing the save prompt. Without it, you’re back to square one with manual confirmation. I learned this the hard way after forgetting it once and wondering why my macro kept asking to save.

Event Handler Tip: As mentioned in Step 5, if you’re working with workbooks that have BeforeClose event handlers, always disable events at the start of your macro and re-enable them at the end. This prevents any custom code from interfering with the silent close. Between us, this is the most common reason I see this macro fail in real-world scenarios.

Security Consideration: When testing in Step 3, remember to re-enable your normal macro security settings after you’re done. Leaving macros enabled permanently can expose your system to security risks. The temporary change is only for testing this specific functionality.

Button Placement: For Step 4, consider that the Quick Access Toolbar button will be visible across all workbooks. If you only want this macro available for specific files, consider adding it to the workbook’s own ribbon instead using the Customize the Ribbon option in Excel Options.

Frequently Asked Questions

What’s the difference between __PROTECT_3 and PROTECT_4__ in VBA?
__PROTECT_5 shuts a specific workbook, while PROTECT_6 exits Excel entirely. Use PROTECT_7__ to close all workbooks and the Excel app, but save critical data first!

Mastering Excel VBA to close a workbook without saving gives you full control over your workflows. 💡 With the simple Workbooks("Name").Close SaveChanges:=False command, you can prevent unwanted prompts and streamline automation. Ready to level up? Try implementing this in your next macro to save time and boost efficiency!