Using Named Range with protection on the worksheet

T

txjag007

I have set up 4 blockes of named ranges for a form I am creating. I need to
lock several cells so the end user can't alter the formulas. When I protect
hte worksheet the named range tabbing no longer works. Anyone have a work
around or another idea?
 
J

Jim Rech

named range tabbing no longer works

I don't think we know what you mean.

--
Jim
|I have set up 4 blockes of named ranges for a form I am creating. I need to
| lock several cells so the end user can't alter the formulas. When I
protect
| hte worksheet the named range tabbing no longer works. Anyone have a work
| around or another idea?
 
Top