VBA code needed for my A level Physics class

[coxash123]

Hello,

As teachers are now remotely teaching from home - it is almost impossible to gauge if my students need additional support. My idea is to 'Cut and Paste' a previous exam paper into excel, allowing the students to answer the questions in the unlocked cells. However, as exams are timed, I want there to be a macro in the background that will allow them to edit the workbook for a given time. I would then want the VBA code to save it and email it to me for marking. This way i can see which students are really struggling and which are EXCELLING......
I'm sure there is a code available. I am very basic and slow in my code writing, so was wondering if any of you wonderful people will be able to help out a Teacher!!!

Coxash123

 

[Trevor G]

Take a look at this link. Free Excel Macro - Close a Workbook after a Time Limit is Reached - TeachExcel.com

 

[coxash123]

Take a look at this link. Free Excel Macro - Close a Workbook after a Time Limit is Reached - TeachExcel.com

thank you for your time! i will look into this.... a whole hearted Thank you....

 

[Trevor G]

Hope it helps with what you need and both your students and you gain from it.