Excel---not allow cutting?

[heathturner]

Hi,

I was just trying to figure out....

How can I NOT allow a user of my worksheet to cut and paste from cells without locking them.

I would like them to be able to input or delete from the cells but not CUT since it will mess up other formulas that apply to the cells.

Thanks,
H Turner

[Spajeoly]

I use this method for when I use cells as buttons(Which I always do).

In your Worksheet_SelectionChange sub just check to see if the cells you want have what you want in them and if not? Make it so.

Here's a small example:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Range("$C$3").FormulaR1C1 = "Weekly stats" = False Then
        Range("$C$3").FormulaR1C1 = "Weekly Stats"
        Range("$C$3").Interior.Color = vbGreen
        Range("$C$3").Font.Bold = True
    End If
End Sub