Macro Help - Trying to apply macro to multiple tabs

In the macro I am creating, I am trying to collapse each tab's groupings to show Outline 1 and then to print all of the selected tabs. I will be creating a print macro button for the users, so I want it to be able to run from the first tab. However, it runs the macro only on the active sheet. Is there a way to modify the coding? See below.

Please Login or Register  to view this content.

Thanks! -Colleen

Hi Colleen,

from what I see you could reduce this code a lot by just addressing the sheet that you want rather than "scrolling" each time. Just address the sheet you want. go into the developer tab and open VBA. Go to the Module and edit your macro there. I don't know if you are just recording a macro until it works, or if you use VBA editor after you record a macro.

Please Login or Register  to view this content.

'etc. you don't need all those scrolls. Finally in the end you have

Please Login or Register  to view this content.

'Try removing this next "Activate." I'm not familiar with the above statement. It appears that it is selecting all the sheets you want printed after having collapsed the rows to the proper level. But if you went through and selected all the sheets then you activated (or selected) a new sheet. It seems like you will lose the array selection, and only the active sheet will print.
[/code]

Please Login or Register  to view this content.

See if that helps.