Old spreadsheet with VBA does not work

[JoeS01]

About 20 years ago I wrote a spreadsheet designed as a series of exercises to teach a student basic addition, subtraction, multiplication and addition. It included a timing of each exercise and also a reset of the exercises using random numbers.
I retired not long after, and have not done any VBA programming since that time. It all looks double Dutch to me now

My 3 x 15 year old grandchildren now have poor basic maths skills, relying totally on calculators, so I would like to get software working for them.
I tried running on MS Office 2010 suite, but without any luck. I have no idea how debug and fix this software. I am 80 years of age, and struggling with technology.

I find I cannot upload this small (367kB) spreadsheet , so have placed it on my private server :
www.dasq.com.au/mrexcel

I am hoping someone in this forum could take a look at it and fix it for me

My kind regards,
Joe

 

[Alex Blakenburg]

I have only tried it a little and it seems to be working fine for me. What is it not doing at your end ?
Have you set the trust settings to enable macros ?

 

[JoeS01]

Hi Alex, yes, when I open the file, it indicates the macros have been disabled. I then enable them using the Options button. As soon as the macro is enabled, I immediately get an error message, as shown in attached file Excel - maths_01.jpg
Pressing the Debug button, I get the next screen showing multiple macros Excel - maths_02.jpg

 

[Alex Blakenburg]

The macro works fine on my machine. Can you have a look at this article and try some of the suggestions there:
eg ActiveX trust setting, run a repair etc,
Fix VBA Run Time Error 57121 - Automate Excel

 

[JoeS01]

I upgraded from Office 2007 to Office 2013 and it now works perfectly

 

[Alex Blakenburg]

Thanks for letting me know. Glad you got it working.