Greetings,

I use several macros in a sheet, however every time one is run the protection settings on the workbook reset and i can no longer use the black + to drag and copy cell information from a cell that has a drop-down.

Is there a way i can ensure that the macro, when reinstating protection on the worksheet, will still allow the user to edit objects (i.e. cells with validation drop-downs)?

Could this be an Excel 2003 thing as I am told it doesn't happen in 2000?