E
Erin
I have a protected sheet (to which I don't know the
password) with data validation applied to certain areas.
I want to copy the lists being referenced by the drop
boxes, but the validation option is grayed out due to the
protection.
I have not been able to find the lists on the sheet and
there are no sheets xlVeryHidden.
Any suggestions?
Thanks!
Erin
password) with data validation applied to certain areas.
I want to copy the lists being referenced by the drop
boxes, but the validation option is grayed out due to the
protection.
I have not been able to find the lists on the sheet and
there are no sheets xlVeryHidden.
Any suggestions?
Thanks!
Erin