FormatCellsProtection. Make sure to checkmark "locked" and "hidden"

ToolsProtectionProtect Sheet. Checkmark removed from Allow user to "select
locked cells"

Note: Excel's internal security is quite weak and easily cracked.

Do not rely on it to keep your formulas and data from prying eyes.


Gord Dibben MS Excel MVP

On Sun, 30 Dec 2007 09:24:01 -0800, pillai
wrote:

I had given some formulas in my excel file. I need to prevent anybody else to
see what formula I had given. If someone can help me to lock a sheet
completely also it would be of great help.
thanks
Pillai