Toby

Don's right-click on the Excel icon and "view code" puts you in the
ThisWorkbook module.

In the left-hand dialog box(general or workbook choices), click "Workbook".
The WorkBook_Open sub/End sub code lines will appear. See right-hand dialog
box for other choices.

Gord Dibben Excel MVP

On Mon, 10 May 2004 11:23:34 -0700, "Toby Erkson"
wrote:

Huh? I got as far as View Code then got lost.

TC-
Open the VBA editor and click on ThisWorkbook. Paste the below code in the
editor window:
Private Sub Workbook_Open()
Call datechk() ' This is where you put your code to execute when the
workbook Opens
End Sub

Nice and simple :-)