"Jim Rech" wrote in message
ExecuteExcel4Macro "Sheet1.SHOW.DETAIL(1," & i & ",false)"

That's not valid syntax. You're melding VB concepts (the "Sheet1") to XL4
macro code.

That's what I thought but curiously it doesn't error.

XL4 code for the most part only works on the active sheet. So make Sheet1
active and delete that reference from the code.

I posted an example of how to do that within the sheet's deactivate event

Regards,
Peter T