How do they fix a typo?

But if you want...

rightclick on the worksheet tab that should have this behavior. Select view
code and paste this in the code window.

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)

Dim myCell As Range
Me.Unprotect Password:="hi"
For Each myCell In Target.Cells
If myCell.Value = "" Then
'do nothing
Else
myCell.Locked = True
End If
Next myCell
Me.Protect Password:="hi"

End Sub

Change the password in both spots.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

bill gillan wrote:

Thanks for your response. Yes, what I want is to allow staff to enter data
into cells but not be able to then delete that information after they have
entered. Therefore have "input permission" but not deletion. I hope this
makes sense.

Regards

Bill

"Peo Sjoblom" wrote:

Do you mean "but once entered information cannot be deleted"?

--
Regards,

Peo Sjoblom

(No private emails please)


"bill gillan" <bill wrote in message
...
I wish to allow people to enter data etc into a cell, but once entered,
that
information can be deleted.

Any help would be greatly appreciated.

Thanks

Bill



--

Dave Peterson