You say you don't want to write a macro, then show a macro declaration for
the change event. Also, you say permanently - so why do you want it in the
change event (a macro).

Mark all the cells in that range as locked, then protect the sheet with a
password.

--
Regards,
Tom Ogilvy


"DukeDevil" wrote:

Hello,

I want to permanently lock columns S:W on my sheet using VBA. I do NOT
want to write a macro. I need it in the following format. Thanks.

Private Sub Worksheet_Change(ByVal Target As Range)

(code)

End Sub