B
Brian
on sheet number one i have a range of cells in the C column which have a drop
list that appears for each cell that gives text items to pick from for
placement in the active cell. I have is so that multiple items can be
selected ( one at a time) and placed in the active cell. ON sheet number two
is where the list items are located. This list is referred to as "namelist"
in the source box in the validation function.
I will usually be entering approximatley 3 or 4 items from the drop down
list for placement in an active cell and this works great until i protect the
worksheet. Then I can only place one item from the list in the cell, because
the macros appear to become disabled when i protect the sheet. When i
unprotect the sheet it still presents this same problem until i close the
workbook and open it again (of course without saving changes.)
Can anyone help me, if needed i could attach the macros i used
please let me know if you need them.
Thank You
Brian
list that appears for each cell that gives text items to pick from for
placement in the active cell. I have is so that multiple items can be
selected ( one at a time) and placed in the active cell. ON sheet number two
is where the list items are located. This list is referred to as "namelist"
in the source box in the validation function.
I will usually be entering approximatley 3 or 4 items from the drop down
list for placement in an active cell and this works great until i protect the
worksheet. Then I can only place one item from the list in the cell, because
the macros appear to become disabled when i protect the sheet. When i
unprotect the sheet it still presents this same problem until i close the
workbook and open it again (of course without saving changes.)
Can anyone help me, if needed i could attach the macros i used
please let me know if you need them.
Thank You
Brian