Here you go - this is how you can add your own code. After searching internet a lot i was finally able to make Mac version of opening all files within a folder and refreshing it automatically - this code does that - i used my work inside the code shared in the link above

 MySplit = Split(MyFiles, Chr(13))
        For FileInMyFiles = LBound(MySplit) To UBound(MySplit)
            On Error Resume Next
                With Workbooks.Open(Filename:=MySplit(FileInMyFiles))
                .RefreshAll
                .Save
                .Close True
                End With
               
            On Error GoTo 0