I am finalising and testing a workbook. One worksheet has suddenly developed
an unexpected behaviour. This followed me trialing the effect of deselecting
one of the option settings in the protection dialog box - "allow user to
enter protected cell". When I returned to the worksheet and click a cell -
regardless of whether it is protected or not I cannot select the desired
cell and the sheet changes to another!. I tried to fix this by reselected
the option to restore me to where I was before. Alas, I still cannot select
a cell in this worksheet only, with the mouse (but I can by keyboard)
without being directed to another sheet - the one where most of the
originating data is collected.

Can anyone help? This is a real problem for me.

I am using Excel 2002 with XP OS.

Regards

Jeff Smith