Exiting a cell when clicking on a command button

Originally Posted by jcl20

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.

The last cell is still considered the active cell,

Private Sub CommandButton1_Click()
MsgBox ActiveCell.Address
ActiveCell.Select
End Sub