I have over 20 years of experience teaching in Secondary (High) School in Australia. I major in Chemistry and all levels of Mathematics. I have been coding Excel Spreadsheets in VBA / Macros for over 6 years and have done several for various colleagues and even for whole school use - all with VBA coding stored in the file.
I have seen so many spreadsheets where colleagues (without a high level of IT confidence) have accidentally deleted the important information that makes the spreadsheet work - hence why I moved to programming them from behind.