Hello to all from Italy.
I am a new member and I hope my English (translated with google translator) is understandable.
I ask help for editing a macro found the net:
it's possible add to
Application.Undo
for example, the block of the color of the cells - the addition of new rows or columns etc ....
I hope that was understandable.
max
__________________________________________________________________
I am a new member and I hope my English (translated with google translator) is understandable.
I ask help for editing a macro found the net:
Code:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Locked Then
MsgBox "You cannot edit this cell", vbCritical
Application.EnableEvents = False
Application.Undo
Application.EnableEvents = True
End If
End Sub
it's possible add to
Application.Undo
for example, the block of the color of the cells - the addition of new rows or columns etc ....
I hope that was understandable.
max
__________________________________________________________________
Mod edit : post moved to appropriate forum …