Select all cells.

FormatCellsProtectionLock all cells.

ToolsProtectionProtect Worksheet.

Allow users to...........select locked and unlocked cells, edit objects.

Add a password if you want.


Gord Dibben MS Excel MVP

On Wed, 17 Mar 2010 10:59:01 -0700, Suju Thomas <Suju
wrote:

Can we add a comment for cells in a protected worksheet. I wanted to allow
feature to only add comment and not allow user to do any other modifications