Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

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.

Re: Lock formula

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".


This archive is from the original message board at
All contents © 1998-2004
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.