I. Hola Compañero, por mi parte no soy usuario habitual de VBA ni de Excel, pero como suelo comentar quisiera trasladarle la información que vi sobre su consulta -enlaces y videos- por si pudiese serle de alguna utilidad mientras le atiende un experto o experta de primera mano.
Imagino que podría utilizarse un script o en parte al menos un programa de macros como JitBit Macro Recorder, pero en verdad no tengo idea.
Le ruego me disculpe la imprecisión y las molestias de tanta lectura, ánimo.
https://www.youtube.com/watch?v=4M2XYspRrSo
https://stackoverflow-com.translate.goog/questions/16448797/run-macro-in-more-than-1-workbook-at-the-same-time?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc
https://www-mrexcel-com.translate.goog/board/threads/how-to-put-macro-on-multiple-machines.149900/?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc
https://superuser-com.translate.goog/questions/10994/what-is-the-best-way-to-share-an-excel-macro-across-multiple-machines?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc
https://www.youtube.com/watch?v=1fewYJ_LEDw
https://www.youtube.com/watch?v=xtVVSPmvJjA
https://superuser-com.translate.goog/questions/1349480/how-to-sync-same-excel-workbook-between-2-computers-on-the-same-network?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc
https://www.mrexcel.com/board/threads/can-i-use-one-macro-in-multiple-computers-simultaneously.617291/
https://www.youtube.com/watch?v=WI-uhkrnk2I
https://xltools-net.translate.goog/excel-loop-macro/?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc
https://it-stonybrook-edu.translate.goog/help/kb/transferring-excel-macros-from-one-computer-to-another?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc
https://www.mrexcel.com/board/threads/can-i-use-one-macro-in-multiple-computers-simultaneously.617291/
https://stackoverflow-com.translate.goog/questions/38646418/excel-macro-is-acting-differently-on-two-computers?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc
https://www.youtube.com/watch?v=VvZMuPMY4C4