Prevent Seemingly Unnecessary Prompts

The types of prompts we are talking about are those that ask you whether you
want to enable macros (when you do not have any), or whether you are sure you
want to delete a worksheet. Here is how to get rid of the most common prompts
once and for all.

Enabling Macros When You Don’t Have Any

Excel’s memory is like a steel trap when it comes to remembering that you recorded a macro in your workbook. Unfortunately, its memory of macros persists even though you might have since deleted one or more macros via Tools -> Macro -> Macros (Alt/Option-F8). Reopen the workbook and you’ll still be prompted to enable macros, even though there are none to enable.

You’ll be prompted to enable macros only if your security level is set to Medium. If it’s set to Low, macros are enabled without a peep; if it’s set to High, macros are disabled automatically for your protection.

Open the VBE by selecting Tools -> Macro -> Visual Basic Editor (or by pressing Alt/Option-F11) and select View -> Project Explorer. (On the Macintosh, the Projects window is always open, so you don’t need to open the Project Explorer.)