MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Lock formula


Posted by Slavko Raspotnik on October 21, 2001 1:08 AM

Can I lock formula in cel that the other people can't change it.


Posted by Stan on October 21, 2001 8:22 AM

Very easily. Select the cell(s) you want to protect. Then choose "Format" -> "Cells" -> "Protection". Select the "Locked" option. Now you need to turn on the protection for the worksheet (or workbook). Choose "Tools" -> "Protection" and select the "Protect Sheet".

Stan