B
Bugzee
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,
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,