I am trying to set up a form in which most of the cells are locked and may
not be edited or formated, but a few cells are left unlocked to enter various
types of data...but each time I go through the lock/protect procedure I am
then unable to tab from one cell to the next...and that is really the main
point of making the form in the first place.

And speaking of forms, can I make links in a word doc, with the same result
as in excel, in which a string of text entered once can be automatically
entered at any number of different spots within the same (or even a
different) document. And can the formats differ, too?

You say sheet in the subject but call it a form several times, are you
having an issue tabbing on a protected sheet or tabbing through controls on
a userform?

"mbawct" wrote in message
...
I am trying to set up a form in which most of the cells are locked and may
not be edited or formated, but a few cells are left unlocked to enter
various
types of data...but each time I go through the lock/protect procedure I am
then unable to tab from one cell to the next...and that is really the main
point of making the form in the first place.

And speaking of forms, can I make links in a word doc, with the same
result
as in excel, in which a string of text entered once can be automatically
entered at any number of different spots within the same (or even a
different) document. And can the formats differ, too?

The tabbing problem that was a bug that was introduced in xl2003 (maybe
xl2002???).

And you can apply any format you want to any cell.

But don't expect the format of a cell with a formula to different cell to change
if you change the format of the "sending" cell.

Formulas can return values--they can't change formats.

mbawct wrote:

I am trying to set up a form in which most of the cells are locked and may
not be edited or formated, but a few cells are left unlocked to enter various
types of data...but each time I go through the lock/protect procedure I am
then unable to tab from one cell to the next...and that is really the main
point of making the form in the first place.

And speaking of forms, can I make links in a word doc, with the same result
as in excel, in which a string of text entered once can be automatically
entered at any number of different spots within the same (or even a
different) document. And can the formats differ, too?

--

Dave Peterson