Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |