We have an Excel based form (Excel 2007) that has been working well, until this afternoon.
Now the Option Buttons are always protected (read only) despite the worksheet being unprotected.
When the worksheet is unprotected, if you click on an Option Button, the worksheet automatically locks by itself, without a password being entered. I belive that is resulting from the last command in the Option Button macro.
To unlock the worksheet again, you need to use the password.
The worksheet is attached. the password is set to: 123
Any insight or suggestions would be appreciated.