Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Outline(grouping) more than 8 levels | Excel Discussion (Misc queries) | |||
Grouping and outline to the left or above | Excel Discussion (Misc queries) | |||
Grouping & Outline | Excel Discussion (Misc queries) | |||
Grouping and outline | Excel Discussion (Misc queries) | |||
Grouping and outline | Excel Programming |