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

Looks like if Excel doesn't see it as an XL4 command it just lets it pass.
This didn't error either:

Application.ExecuteExcel4Macro "NotSubWithThisName"

--
Jim
"Peter T" <peter_t@discussions wrote in message
...
"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