Excel 2000
 

Hi, I have created a test using drop down boxes for the answers using excel 2000. I am looking to use a command button from the control toolbox to save, e-mail the entire workbook to a specific address, then reset the worksheet back to default answers and close the whole workbook. Is this possible? Is there a code that would accomplish all of this?
Thanks, John

EggHeadCafe - Software Developer Portal of Choice
Win a share of $400 by posting to our messageboard
http://www.eggheadcafe.com/tutorials...400-by-po.aspx