Here is a tutorial to lock or hide only the formula cells in an Excel workbook. You can also lock formulas in all worksheets in a workbook.

How to lock cells in Excel Open the Excel workbook and select all cells in the worksheet with the cells you want to lock by pressing the Ctrl + A buttons on your keyboard.

The bare bones VBA code A simple list of sheet names is easy to generate using VBA thanks to the Worksheets collection. Listing A shows a simple For Each loop that cycles through this collection.