tab between unprotected cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top