Chuck,

Place a test at the beginning of the auto execute macro:

Sub Auto_Open()

If ThisWorkbook.Worksheets("Sheet1").Range("A1").Valu e < "MyCode" Then Exit Sub

ThisWorkbook.Worksheets("Sheet1").Range("A1").Clea r

.... do stuff


--

John Green - Excel MVP
Sydney
Australia


"CLR" wrote in message ...
Hi All......

Is it possible to write a macro that can be installed in a workbook and will
Auto-run the next time the workbook starts up and then never run again
until/unless a special code number is re-inserted in a specific cell?

TIA
Vaya con Dios,
Chuck, CABGx3