Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplicate Range Names by worksheet FlaAl Excel Discussion (Misc queries) 0 May 24th 06 06:14 PM
How do you Identify text as a named range in excel DMDave Excel Discussion (Misc queries) 6 May 8th 06 12:48 AM
Need formula to lookup a named range DMDave Excel Discussion (Misc queries) 5 May 7th 06 04:18 AM
VLookup Error in Part of a Named Range Dallas64 Excel Worksheet Functions 6 April 18th 06 03:13 PM
Define a range based on another named range Basil Excel Worksheet Functions 2 February 21st 05 02:47 PM


All times are GMT +1. The time now is 03:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"