Hello,
looking for a bit of advice with my spreadsheet, i am trying to copy a template stored on sheet2, the template has has a column with drop down lists, when i try to copy it onto sheet one with no sheet protection it works fine, the drop down lists function correctly, but when i protect the sheet the format is copied but the dropdown lists don't work.
Any help would be greatly appreciated.
Thanks in advance.