Writing some VBA-Code to an excel file

[Felicitas]

Hello dear community,

is there a way to load some vba-code to a xlsx-file?

i want to apply this code :

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not (Intersect(Target, Range("e:e")) Is Nothing) Then
        Target.Interior.ColorIndex = 3
    End If
End Sub

the code marks every cell the user did a change to.

Any good ideas?

Thank you so much ;)

[Subz]

Maybe the following post will help:

 

[junkew]

• no, xlsx normally does not have macro's you should switch to xlsm
• no, normally security settings will not allow to do this
• yes if above is allowed you can alter your workbook with the vbide object model
  https://bettersolutions.com/vba/visual-basic-editor/extensibility-object-model.htm
• no, in general I would do this directly from excel vba editor