Are we talking about only one date on the hidden sheet that the user is
prompted to update each time the workbook is opened?

I'm assuming that it's not the current date that is being entered because
you could accomplish that with =TODAY()

Francis Hayes (The Excel Addict)
www.TheExcelAddict.com

"SixBowls" wrote:

I have a spreadsheet that requires the user to enter a date on a hidden tab.
The date is used for calculations throughout the spreadsheet.

On opening the sheet, I would like to have some sort of reminder/prompt to
update the date and if possible do the entry without unhiding the sheet.