EXCEL 2013 Macro code locks the method of a cell that contains a formula

We entered a number of function formulas in the Excel cell, gave the form to others, and feared that she accidentally changed the function, resulting in the subsequent calculation of the data error. How do I lock these cells? So that it cannot be modified? The method of using macro code can be accomplished.

① we open the Excel2013, press the ALT+F11 key on the keyboard to bring up the VBA code Editor and create a new module.

② copied the code in, and I added some comments to make it easier for everyone to understand.

The ③ code is as follows:

④ copy complete, return to the Excel interface, click the development tool-macros, select the macro, you can execute.

Note : More wonderful tutorials Please pay attention to the triple Office software tutorial section, triple Computer office group: 189034526 welcome you to join