Step 1

Select all cells then right click > format cells > protection tab > untick locked.

Step 2
Next select cells with formula by pressing F5 > special > Formulas and while selected repeat step 1 and if you want the formulas hidden also tick hidden

Step 3
Protect the sheet

VBA Noob