Tab through an Excel form

[jayr911118]

I would like to restrict a a form to only having a few cells that are editable. I also want the tabbing on the form to jump through those specific cells. Is there any way to do this? Thanks in advance.

 

[Cbrine]

Take a look at worksheet protection. It will do all those things. Just unlock the cells you want to be able to tab through, then turn on the protection.

HTH
Cal

PS-Right click on the cell, select format, click on the protection tab, then click the checkbox for locked so it's blank.
Protect sheet
Tools....Protection...Protect sheet.

 

[Smitty]

You can use worksheet protection.

Select the cells that you want editable (you can select multiple non-contiguous cells with CTRL+Left-Click), then goto Format-->Cells-->Protection-->Uncheck Locked, followed by Tools-->Protection-->Protect Sheet-->Add a password of you want.

Tab will then move you to each subsequent cell from left to right, then down.

Hope that helps,

Smitty