Excel pull down menu
 

I have a worksheet that has many spaces with data inserted. Some are pull
down menus. I made a macro button that will clear all the data, except it
won't do the pull down menus. Can I write into the macro to set the menus
back to a default selection and can I get the macro to uncheck boxes?
--
ken