No. Microsoft do not let us see all the VBA coding that makes Excel work.
Probably Microsoft do not want us to see it all. If we could see it all, then some people could probably steal all the coding and make their own Excel without Microsoft!

Microsoft only let us see a very very small amount in a clean file.
Mostly they let us have access to codings that do things when events, like opening, or changing things, happen. But they hide, (make invisible), their coding. But we can add our coding in those places.

The main macro I did for you I put in the Microsoft coding that works when you change something in a cell. That is why it works automatically when you change something. Not many people know how to do that. Only people like me with big cock and big brain

The start of the main coding I did for you https://www.excelfox.com/forum/showt...ll=1#post23211 , looks like this:

Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Rem 1 what cell changes don't interest me
 If Target.Cells.Count <> 1 Then Exit Sub '  More than one cell changed, for example by pasiting new range in
 If Target.Row = 1 Then Exit Sub '        '  Row 1 is always header so of no interst for adding data
' If Target.Value = "" Then Exit Sub '     '  If we empty a cell we don't want the macro to do anything
Target is the cell or cells that get changed.
The first few code lines check to see
_ If you changed more than one cell
_ or If you are in the first row.
In those case I exit the macro, since I assume we don’t want to do anything automatically in those cases


The coding called Sub Worksheet_Change(ByVal Target As Range) is always there in a new file and there is already lots of coding in it. But we can’t see it. Microsoft made all their coding invisible.

If you look at that macro in a new file it looks like this to us
Code:
Private Sub Worksheet_Change(ByVal Target As Range)



















End Sub
Microsoft have lots of coding in it, but they make that invisible to us. But they let us put extra coding in it.