I have a workbook with many unprotected columns which contain dropdown lists.
When I protect the workbook with the code: "wSheet.Protect Password:=Pwd, DrawingObjects:=True, Contents:=True, Scenarios:=True" it is then not possible to copy down using the cell handle (small square at bottom right of cell) because the cursor changes from a "+" to a small hand.
It seems to be the "DrawingObjects:=True" that causes this.
Any solutions?