View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
txjag007 txjag007 is offline
external usenet poster
 
Posts: 5
Default Using Named Range with protection on the worksheet

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?