Excel problem, tab settings. Please help!!?

Question

I have just built a program to allow my works to input income and outgoings data and produce graphs, reports etc. The input screen requires very little information, as macros & functions etc complete nearly everything. There are a few cells where input is required: how do I make it so the only cells that can be accessed are the cells that require input? Say using the TAB key will cycle between the input cells only. This problem has bugged me for years. I've used Excel5.

Answer 1

The above answers are quite correct, what I did on top of what has been said was to hold the control key down and click each cell that is required to be filled in, (click the second required cell first, go through the sequence and click the first required cell last.) Let go the control key, and give these cells a range name. Set your selected cells to unlocked as said before. When you want to update all the data in the cell range, do it by macro, and put the last macro item as a goto your range name and clear contents. The next series of entries will follow sequence as you press enter to complete each cell.

Answer 2

First, I would recommend updating to a more recent version of Excel. Excel 5 was the very earliest version of Excel that supports VBA.

Your version of Excel is (please don't take offense) kind of ancient in a way.

IF Excel 5 will do it, select all of your input cells and select format from the Menu Bar. When the Format Cells dialog window comes up select the Protection tab and uncheck the Locked checkbox and click OK. Then go to Tools > Protection > Protect Sheet. On the Protect Sheet dialog window uncheck "Select Locked Cells". This will prevent the users from being able to select the locked cells. Enter a password for the worksheet and click OK. Now when you click tab, Excel should only tab between the unlocked cells.

The only problem is that I am referencing Excel 2003. Your version is much older than 2003 and you may not be able to protect the worksheet or your menu lists may not be the same.

Your version of Excel is around 13 years old if you have Excel 5. It's definitely time to get thinking about upgrading Excel.

Answer 3

in excel click Crtl + A right click go to format cell - go to the Tab protection now go check locked it should already be there. now go to each individual cell which you want to be able to edit and do the same thing so right click on the cell go to the protection tab and make it not locked( so make sure your locked box is unchecked)

do that for the cells you want to be able to cycle through or edit

Now go to Tools -> Protection -> Protect sheet -> choose a password if you'de like this is for unlocking later. but you dont need a password

enjoy now you can cycle by using tab only