| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel List on Protected Sheet
I have a range that is an Excel List.
Regardless of whether all cells in the list are unlocked (or if some columns are locked), if the sheet is protected, the list doesn't activate (so the list doesn't extend to include the new row). Is there a way around that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
| UDF doesn't work on a protected sheet in Excel 2003 | Excel Discussion (Misc queries) | |||
| UDF doesn't work on a protected sheet in Excel 2003 | Excel Discussion (Misc queries) | |||
| Protected sheet accepting values from List | Excel Discussion (Misc queries) | |||
| How can you insert a picture in a protected Excel Sheet? | Excel Worksheet Functions | |||
![Lori H.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
