Does anyone know how to set a spreadsheet to only tab to certain cells in a
given row? For example, in row 1, I want user input in cells B1, D1 & G1.
Can I make it so that on row 1, it automatically tabs just to these cells? I
still want the other cells viewable. Thanks.

BrentM

You can lock the cells (or entire column) and then protect the workbook.
Menu Format--Cells... ProtectionTab, Menu Tools--Protection--Protect Sheet

"brentm" wrote:

Does anyone know how to set a spreadsheet to only tab to certain cells in a
given row? For example, in row 1, I want user input in cells B1, D1 & G1.
Can I make it so that on row 1, it automatically tabs just to these cells? I
still want the other cells viewable. Thanks.

BrentM

See http://www.xldynamic.com/source/xld.xlFAQ0008.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"brentm" wrote in message
...
Does anyone know how to set a spreadsheet to only tab to certain cells in
a
given row? For example, in row 1, I want user input in cells B1, D1 & G1.
Can I make it so that on row 1, it automatically tabs just to these cells?
I
still want the other cells viewable. Thanks.

BrentM