| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a named range be protected???
For example, If I had a worksheet used to collect 10
financial values, with the 10 cells named FinVal1 thru FinVal10 respectively, locked all other cells on the sheet, protected the sheet... Now, as an example if a user Cuts the cell named FinVal1 and pastes it over the cell that is named FinVal6, then FinVal6 will no longer exist. Is here a way to prevent users from pasting cell obects over others that are named? This silently creates havoc elsewhere in the spreadsheet that may reference the former named range. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List Box - For Input Range can I use named range in another workbo | Excel Worksheet Functions | |||
| Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
| automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
![John D[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
