tab key use in a created template
We don't know which method you are using to Tab through the cells.
If using sheet protection and unlocked cells you can go forever.
If using a named range, you are stuck with 255 characters in the Refers to:
dialog box.
Gord Dibben MS Excel MVP
On Tue, 29 Jul 2008 13:11:01 -0700, Audra
wrote:
I created a worksheet to function as a standard template to be updated by a
group. The tab key works for only the top half of the protected document. I
have 184 lines and only goes through less than 80 of them. I cannot/do not
know how fix it. Does excel have a limit on how may fields can be input like
that??? I am perplexed!
|