Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protected DataLists - and no VBA?
I asked this question the other day in the straight Excel group, but thought
I'd try again here. I've never used the Lists much that are available by clicking DataList. They seem like they'd be a great way to bypass lots of VBA if you can insert and delete rows while protecting the worksheet. However, it looks like this is not possible, and you can only have the full List functionality if the sheet isn't protected. Specifically, when I protect the sheet the List menu's InertRow option is grayed out and the last row - the one with the asterisk for entering a new record - isn't available. Am I missing something, or is it true that when the sheet is protected these parts of the List functionality aren't avaible? Thanks in advance, Doug |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lists on a protected worksheet | Excel Discussion (Misc queries) | |||
Using drop down lists on protected worksheet | Excel Discussion (Misc queries) | |||
1004 Cell Protected Error for data validation lists when locked and protected | Excel Programming | |||
Excel Lists in a Protected Spreadsheet | Excel Discussion (Misc queries) | |||
How to let users add lines in lists in protected worksheets? | Excel Discussion (Misc queries) |