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.

A user can enable the Formula bar just as easily as you disabled it. Pressing F2 to engage in-cell editing also displays the formula and allows users to make changes.