see the Excel VBA Help for types of restrictions on InputBoxes, unfortunately Dates aren't included.
Also, Auto_open macros have been superceded by the Worksheet_Open event of the Workbook object - see
http://www.excel-it.com/Forum/viewtopic.php?t=11
Bookmarks