Select all cells that DO NOT require to be locked, go to
FormatCellsProtection and remove the check mark beside "Locked". Click
OK. Then go to ToolsProtect Sheet and check all boxes and put in a
password. This way people can type in cells unprotected (filling out forms,
etc.) but cannot alter cells that have been left locked. However, you must
password protect the file for this to work, and you must do it in this order.
Hope this helps. Connie

"speary" wrote:


Is there a way I can lock my formulas so no one can change them when i
send my spreadsheet out? I have about 50 cells with formulas in them in
4 or 5 columns and I need them all locked. Thank you for any
suggestions.


--
speary
------------------------------------------------------------------------
speary's Profile: http://www.excelforum.com/member.php...o&userid=24959
View this thread: http://www.excelforum.com/showthread...hreadid=389055