| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
| How do you Identify text as a named range in excel | Excel Discussion (Misc queries) | |||
| Need formula to lookup a named range | Excel Discussion (Misc queries) | |||
| VLookup Error in Part of a Named Range | Excel Worksheet Functions | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
Linear Mode
