Selecting multiple sheets for a "assign-label-code"

Hi guys,


I have multiple excel sheets with names like:
PG1 2013
1. brand 2012-2013-10. brand 2012-2013 and more.

I would like your help with one of these suggetions:

1. Run this code on only the excel sheets that need labels to be assigned
Or
2. Run the code on all sheets even though far from all need a label assigned.

Code

Please Login or Register  to view this content.

How can I run this code on multiple sheets or all of them without making a code that is 3 pages long..
The code works on each individual, but since it's going to be a part of button I need "it" to know what sheets to be run on.

Thank you in advance.

And how is the code to know which sheets need labels assigned?

The following will loop through each sheet in your workbook and apply labels. If the sheet doesn't have a chart, or the label code fails for some other reason, it will just move on to the next.

Please Login or Register  to view this content.

Yes, you can't select hidden sheets. Are the charts on hidden sheets? If not, you might add "if ws.visible then ... ". If they are hidden, and you still want the labels added, set ws.visible = false first, then reset to true later if needed.

All the charts are in fact on unhidden sheets and the data that creates the charts are hidden, but since i'm only adding labels that should not interrupt the code if only select sheets that are visible?

So the new code is like this:

Please Login or Register  to view this content.

Thank you once again.

No, you have it backwards

Please Login or Register  to view this content.