Diana wrote:
Is there anyway to protect or lock a function in a cell, so that others can't
alter the function?


Look at "About worksheet and workbook protection" in the help file.