Hello again, I have the following code that deletes a cell once I click the linked button in the worksheet. What I was wondering, was is it possible to edit this so it only deletes the contents rather than the cell itself?
Tanks,
John.
[vba]
Sub deleteMe()
ActiveSheet.Unprotect Password:="password"
ActiveCell.Delete
ActiveSheet.Protect Password:="password", DrawingObjects:=True
End Sub
[/vba]