I have a sheet that needs certain columns to be locked so the sheet has to be protected. But when the sheet is protected, i can no longer use any drop down lists. does anyone know how to get around this to be able to use the drop down lists. thanks in advance.