Private Sub Worksheet_Change(ByVal Target As Range) is not visible in the macro list

[Rasto800]

Hi, if I save this type of code in a module in the workbook, it doesn't show up in the macro list at all, so I can't run it. The standard macro "sub macro1()" works fine. Where could be the problem? I tried save it in "personal.xlsb" as well, without success.

It doesn't matter what the code is supposed to do, it doesn't even appear that way:

Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

Thank you very much for your advice.

 

[James006]

Hi,

These Event macros are stored in the respective Sheet Module ...
A shortcut to jump directly to the Sheet Module :
Point your cursor on the Tab name ... right-click to open sub-menu ... and select the 5th choice : View Code

 

[Rasto800]

Hi,

I know how to get there, I know where to enter the code, but there is no way to run it - when I press F5 there is nothing in the list of macros even though the code is saved and should be visible.

 

[Fluff]

You do not "run" event code. It is triggered automatically & in your case that is when a cell on the relevant sheet is changed.

 

[Rasto800]

My mistake, I only had the code header there, thinking it was supposed to appear in the macro list.

OK, it works, thank you for your kindness.

 

[Fluff]

Glad we could help & thanks for the feedback.