Tabbing over to particular cells

[bdschleich]

I have created a spreadsheet that is a template for a form that needs to be filled out. Within the form, there are only about 6 cells that need to have information entered in to them (they are not contiguous). Is there a way to have the spreadsheet set up so that when hitting tab and/or enter, the cursor will only go to those 6 cells? Thanks!

 

[Joe Was]

Select the cell
Excel Toolbar: Format - Cells... Protection [Tab], unlock the Locked CheckBox
Do this for each cell that is to be tabed to.

Tools - Protection...
Check the "Select UnLocked" CheckBox
Give Password if you like or leave it blank.

Now only these cells can be selected.

 

[bdschleich]

Protected Cells

I have a spreadsheet where there is an option to select from two radio buttons: when selecting one button it shows certain cells and when you select the other button, it hides certain cells. (someone else made the worksheet, so I am not positive, but I think it is a macro?)

I need to have the spreadsheet protected so that only certain cells are unlocked. I don't know how to protect the spreadsheet while keeping the aforementioned radio button unlocked.

Any thoughts?

 

[Smitty]

You didn't mention if Joe's advice worked for you before diving into a new topic.

On to that, can you post the code?

If you don't know where, then hit Alt+F11 to open the VB Editor and look through all the modules on the left under your project name, i.e. VBA Project (Bob's Workbook.xls).

Look for code in there and post what you find.

Smitty

 

[bdschleich]

Joe's suggestion did in fact work. I believe the code is as follows:

Private Sub ListBox1_Click()
yes
no
End Sub

 

[bdschleich]

I was looking closer and found additional code that relates to the buttons I was referencing:

' New Hire Info
'

'
Rows("20:20").Select
Selection.EntireRow.Hidden = True
Range("B14").Select
End Sub
Sub Departure()
'
' Departure Macro
' Departure Information
'

'
Range("A16").Select
ActiveCell.FormulaR1C1 = "Last Day:"
Rows("19:21").Select
Selection.EntireRow.Hidden = False
Rows("18:19").Select
Selection.EntireRow.Hidden = True
Range("B14").Select
End Sub
Sub NewHire2()
'
' NewHire2 Macro
' New Hire Info Macro to utlize after Departure Info Macro was already utilized.
'

'
Range("A16").Select
ActiveCell.FormulaR1C1 = "Start Date:"
Rows("17:22").Select
Selection.EntireRow.Hidden = False
Rows("20:20").Select
Selection.EntireRow.Hidden = True
Range("B14").Select
End Sub

 

[Smitty]

Since you started over here, I'm locking this post.

Please stick to your Original Post! That way the same topic isn't scattered all over the board for multiple people to answer.

Smitty