Protect Cell from being edited
 

Can I protect cells from being edited after a user has entered
information?

I am using a macro for the user to enter their name in to a cell see
below:

Sub Ang()
'
' Ang Macro
' Macro recorded 16/02/2006 by stapen
'

'
ActiveCell.FormulaR1C1 = "Angela"
Selection.Locked = True
Selection.FormulaHidden = False

End Sub

The problem I have got is that the worksheet is protected, so it won't
protect the cell. But I don't want to unprotect the whole worksheet. I
don't want users to be able to overwrite information other users have
already entered.

:confused:


--
alexandra60
------------------------------------------------------------------------
alexandra60's Profile: http://www.excelforum.com/member.php...o&userid=31215
View this thread: http://www.excelforum.com/showthread...hreadid=513560

Protect Cell from being edited
 

Alexandra,

you can unprotect right before your actions and protect immediately
afterwards

ActiveSheet.Protect
ActiveCell.FormulaR1C1 = "Angela"
Selection.Locked = True
Selection.FormulaHidden = False
ActiveSheet.Unprotect

Does this help?

Kostis Vezerides