When creating an Excel template you may want to turn off the formula bar to limit unwanted user actions.
If you are using a spreadsheet and the formula bar is missing you may want to turn it back on.
To toggle the formula bar On or Off:
On the main menu bar
1. Click Tools
2. Select Options
3. Select the View tab
4. Removing a checkmark next to the Formula bar option will remove the formula bar. Placing a checkmark next to the Formula bar option will add the formula bar. Click OK.

To do this from VBA take a look at Excel VBA: Turn On Formula Bar - Turn Off Formula Bar