Possibly using the Inputbox function in the Workbook_Open Event.

--
Regards,
Tom Ogilvy

"Jessy Jules" wrote in message
...
Hi I have set up a spreedsheet template and would like to
be able to enter the date in a 'pop up' menu when opening
the template so that it will enter it in each worksheet in
a different place on each of these worksheets. Is this
possible? How?
Jessy