In defined names, you can hide them. for cells, you can check the hidden
and locked properties and then protect the worksheet.

Password protection on sheets is pretty easy to break however.

--
Regards,
Tom Ogilvy

"alldreams" wrote in message
...
Is there a way to password protect formulas in cells and
Defined Names?

Thanks for your help

Johann