Is there VBA code to read data from the check boxes and drop downs or are they simply linked to cells on the worksheet?
The chances of resolving this by a discussion on the forum are pretty remote. Can you blank your worksheet then click my yellow envelope to e-mail me. I'll reply and you'll be able to send the worksheet back to me as an attachment.
Basically I need to know the names of all of these objects to clear them. Also, if you made your macros using the macro recorder I can probably neaten them up.