How to enable a macro in Excel for one time only If you want to run a particular macro just one time, you can configure Excel's security settings for that as well. 1.

Click the Enable Content button in the warning message to enable macros without risks. You can now view and run the macros on another computer by clicking on Macros in the Developer tab. 2.

If a user clicks on the 'Enable Content' button, ... Word or Excel will prompt you to 'Enable Editing' or 'Enable Content' again. Clear Trusted Documents.

Before Word or Excel executes macros in a document, though, Office requires you to click on the 'Enable Editing' or 'Enable Content' buttons, which you should never do.