View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Using Named Range with protection on the worksheet

named range tabbing no longer works

I don't think we know what you mean.

--
Jim
"txjag007" wrote in message
...
|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?