Hello,

I have a worksheet that I have protected apart from three cells. I intend for the user to enter data into these cells and then click on a command button to enter this data onto another sheet.

The problem is: after I have entered data into the third cell, I cannot click on the command button without 'deselecting' the cell. Is there a way to shift the focus off the cell to click the command button without leaving the cell in question?

I was thinking of something along the lines of a 'before click event'.

Many thanks.