tab index to move around within unprotected cells
 

Hi,

I'm not sure that I'm in the right newsgroup but I hope someone has a
suggestion for me. I created an Excel spreadsheet that has about 12 fields
in in that are editable by users, the rest of this spreadsheet is protected.
Is there a way that I can program a tab index to move through these 12
fields?

Thanks in Advance,
JeffH

tab index to move around within unprotected cells
 

Hi Jeff

If you protect your sheet by default you tab to the unprotected cells by row

Maybe you can use this

Sub test_1()
Dim myRange As Range
Dim myCell As Range
Dim myAns As Variant

Set myRange = Range("I3,K7,m11")

For Each myCell In myRange.Cells
myAns = InputBox _
(prompt:="Please enter something for cell: " & myCell.Address, _
Title:="Get Data")
If myAns < "" Then
myCell.Value = myAns
End If
Next myCell
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"JeffH" wrote in message ...
Hi,

I'm not sure that I'm in the right newsgroup but I hope someone has a
suggestion for me. I created an Excel spreadsheet that has about 12 fields
in in that are editable by users, the rest of this spreadsheet is protected.
Is there a way that I can program a tab index to move through these 12
fields?

Thanks in Advance,
JeffH

tab index to move around within unprotected cells
 

Hi Jeff,
If you Lock all of the cells in the worksheet by
Selecting all
Right Click and Format Cells
Protection
Check Lock Cells

Then on those 12 you want to give the ability to update, right click
those and unlock.
Then when you are protecting the sheet, Allow users to select only
unlocked cells.(Check this box only)