Outline grouping within macro?
 

Hello somebody out there,

I am trying to hide some rows (using outline grouping), containing macro
buttons, before printing/publishing the spreadsheet. I am trying to achieve
this with a macro which is attached to one of the buttons being hidden.

I recorded the macro and attached it to the button. the code generated was:

Rows("5:11").Select
ExecuteExcel4Macro "SHOW.DETAIL(1,11,FALSE,,4)"

Upon clicking the button I received a run-time error '1004' message: "you
have entered too many arguments for this function."

I looked at the debug definition which said "cannot jump to
'ExecuteExcel4Macro' because it is hidden."

Can any one point me in the right direction?

Thanks very much,