Hi,
XP and 2003.
I should get this to work:
Private Sub Worksheet_Deactivate()
....
For i = 1 To 14
ExecuteExcel4Macro "Sheet1.SHOW.DETAIL(1," & i & ",false)"
Next i
.....
end sub

My problem is he
ExecuteExcel4Macro "Sheet1.SHOW.DETAIL(1," & i & ",false)"
That Sheet1 is not functioning when it is in Private Sub
Worksheet_Deactivate(). It tries to run it in the activated sheet. Is it and
how is it possible to get it to run in Sheet1?

Thanks in advance
MakeLei