Outline grouping within macro?

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top