Brian,

First let me thank you for your help.

I am familiar with VB and use it in Access alot, but I can't seem to find
the workbook class module. Could you please let me know where to look?

thanks!

"Brian Taylor" wrote:

If you want the line to run when the workbook opens then go into the
ThisWorkBook class module, select workbook, and then open. It should
look like this:

Private Sub Workbook_Open
Sheet1.Range("B2").Value = Date - 1
End sub

If it is when the worksheet is activated then go into the sheets code,
select worksheet, then the activate event. It should look like this:

Private Sub Worksheet_Activate()
Me.Range("B2").Value = Date - 1
End Sub