I have a drop down list which includes the months of the year. I have a sub that copies the current file, and creates a new year file by naming it with a different name and zeroing out data. The only thing is that the drop down list stays on what if was last, this case December. Is there a way to force the drop down to go to January when my sub creates the new year file? The drop down list was not created in vba, it was created on the worksheet using data validation.
Thanks
Gary