tab between unprotected cells
 

I have a workbook with protected cells that users will use the tab key to
move to each unprotected cell to enter data. There is a cell that contains
check boxes and they will need to click a check box to make a selection --
and then the tab function is disabled. They have to click in the next box to
continue. Is there any way for the tab function to work?

tab between unprotected cells
 

I put a checkbox from the control toolbox toolbar on a worksheet.

I doubleclicked on that checkbox to see its code.

I put this code in that window.

Option Explicit
Private Sub CheckBox1_Click()
ActiveCell.Activate
End Sub

Then I went back to excel. I protected the worksheet and when I clicked on the
checkbox, the activecell was re-selected.



LesaT wrote:

I have a workbook with protected cells that users will use the tab key to
move to each unprotected cell to enter data. There is a cell that contains
check boxes and they will need to click a check box to make a selection --
and then the tab function is disabled. They have to click in the next box to
continue. Is there any way for the tab function to work?

--

Dave Peterson