Old spreadsheet with VBA does not work

JoeS01

Well-known Member
Joined
Jun 25, 2005
Messages
832
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
 
Last edited by a moderator:

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
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 ?
 
Upvote 0
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
 

Attachments

  • Excel - maths_01.JPG
    Excel - maths_01.JPG
    226.5 KB · Views: 32
  • Excel - maths_02  Medium.JPG
    Excel - maths_02 Medium.JPG
    203.9 KB · Views: 27
Upvote 0

Forum statistics

Threads
1,223,231
Messages
6,170,884
Members
452,364
Latest member
springate

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top