Financial Presentation in Excel has a Summary Macro & Detail Macro - need to add rows

[GiantsYank20092011]

I am working on a financial presentation for 25 cost centers in Excel (each tab has two same two macros) - the two macro are presentation views:
1) Summary View - hides and conditional formats a bunch of rows
2) Detail View - unhides everything and has differrent conditional formatting

I need to add in two more rows in middle of each with a new financial measure , everytime I add in row it screws up my formatting and I can;t get it to work.

Additionally, do I need to macro in each page in workbook, or can I do it all at once.

Thanks

[TMS]

How would you suggest we respond to your question? No data, no code, no workbook, no process information ... no clues.


Regards, TMS