Macro to Hide formulas in a worksheet

Hide formulas in the entire worksheet

```Sub HideFormula()
Cells.Select
Selection.Locked = True
Selection.FormulaHidden = True
ActiveSheet.Protect Password:="Pass"
End Sub```

Note: “Pass” is the password used for protecting the worksheet and can be replaced by the password of your choice.

Hide formulas in the selection

```Sub HideFormula()
Selection.Locked = True
Selection.FormulaHidden = True
ActiveSheet.Protect Password:="Pass"
End Sub```

How to use codes shared here?