even though the value for [ReformatingCompleted] seems to have been set to
"True", I'm not able to test for it correctly;
could someone proof this short code for me? (it's prob an obvious mistake...
u know how that goes...)

--------------------
ActiveWorkbook.ActiveSheet.Names.Add Name:="ReformatingCompleted",
RefersToR1C1:="=""True"""


If ActiveWorkbook.ActiveSheet.Names("ReformatingCompl eted").Value = "True"
Then
Exit Sub
End If
--------------------


thanks in advance,
mark