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?