Protect Cell from being edited

A

alexandra60

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

I am using a macro for the user to enter their name in to a cell se
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'
protect the cell. But I don't want to unprotect the whole worksheet.
don't want users to be able to overwrite information other users hav
already entered.

:confused
 
V

vezerid

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to format cells on several worksheets 2
Suppress printing workbook 2
Protect Number Format Only 6
Runtime 1004 error -- insert method of range class failed. 1
Modifying a protect unprotect macro 10
protected cells can be deleted?! 7
VBA Macro Training in Chennai 0
Use a password in VBA ActiveSheet.protect & ActiveSheet.unprotect? 2

Top