Tick:yes is not working in workbooks.

The worksheets in worksbooks don't allow users to tick yes. This is the first time I met this kind of problems. I am not sure whether this is easy to be solved. Thanks for your assitance. ZNPS