input box upon workbook open

[papa jonah]

I want to have an input box that will ask for a date when a workbook is
opened.
I want to be able to us the date that is input in code that will be run
from a macro.

The reason I want the input box upon open instead of when the macro is
run, is because the end user uses the file repeatedly for multiple
calculations. This date will be applied to all of the calculations,
and I don't want the user to have to enter the same date over and over.

I assume that I need something like a "public enddate as date" in the
ThisWorkbook object.

This however doesn't work. What do I need to do to be able to
reference the inputed date later?

TIA

 

[JulieD]

Hi

you'll need to store it in an "out of the way" cell somewhere and i'ld
advise on before_close code to clear the cell to ensure that next time the
workbook opens the new date gets entered and used.

Cheers
JulieD