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

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

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

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

Hi Dave

Thanks for your reply. It has not quiet worked how I wanted it to. If I
explain what I want then maybe it will help. I want to create a form that
staff will be required to input data into. There will be a range of cells
where they have to enter data. The columns will be C & D with rows 1 to 20.
So if they were to enter a figure in column C3 once entered they cannot
change it. I have pasted your code into the spreadsheet. It allowed me to
enter into a cell once but then not delete it. When I went to test this in
another cell I could not enter or delete. Any more advice/help would be
greatly appreciated. I do thank your for your time.

Regards

Bill

"Dave Peterson" wrote:

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

The first thing you have to do is lock the cells that can't be changed
(formulas/headers/instructions). And unlock all those cells (C1:d20) that can
be changed once.

Then give it a try.

bill gillan wrote:

Hi Dave

Thanks for your reply. It has not quiet worked how I wanted it to. If I
explain what I want then maybe it will help. I want to create a form that
staff will be required to input data into. There will be a range of cells
where they have to enter data. The columns will be C & D with rows 1 to 20.
So if they were to enter a figure in column C3 once entered they cannot
change it. I have pasted your code into the spreadsheet. It allowed me to
enter into a cell once but then not delete it. When I went to test this in
another cell I could not enter or delete. Any more advice/help would be
greatly appreciated. I do thank your for your time.

Regards

Bill

"Dave Peterson" wrote:

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


--

Dave Peterson