Here is a video recording of the Macros in Excel workshop that I ran (in Feb 2019) for teachers needing to learn about macros as they were being added to the Computer Applications Technology curriculum. It was a lot of fun and I think all the participants enjoyed it too!
If you are interested in the notes and video from the workshop, you can purchase the notes here.