V
vecia
Hi,
I’ve been asked to look at making past exam papers into online tests.
I don’t know anything about programming, so the way I’ve done it is t
use form controls in excel. I was thinking I could set it up as
template with data tracking on the network so people could open a cop
on their machine, then when they save it, it would feed back into
database that could do the marking.
I’m ok as far as designing the worksheet so it has option buttons etc
for each question.
My first problem is that, having created the worksheet, once it i
protected, I can’t select any of the option buttons, even though I hav
unlocked the buttons in ‘format control’.
I really need to make it so the users can’t even click anywhere excep
the option buttons and 3 cells (for name/surname and form).
Can I also make it so that users can’t use any of excel’s toolbar
whilst taking the test
I’ve been asked to look at making past exam papers into online tests.
I don’t know anything about programming, so the way I’ve done it is t
use form controls in excel. I was thinking I could set it up as
template with data tracking on the network so people could open a cop
on their machine, then when they save it, it would feed back into
database that could do the marking.
I’m ok as far as designing the worksheet so it has option buttons etc
for each question.
My first problem is that, having created the worksheet, once it i
protected, I can’t select any of the option buttons, even though I hav
unlocked the buttons in ‘format control’.
I really need to make it so the users can’t even click anywhere excep
the option buttons and 3 cells (for name/surname and form).
Can I also make it so that users can’t use any of excel’s toolbar
whilst taking the test