Hi Metallo

You can use a array if you know the names of the 10 sheets
For Each sh In Sheets(Array("Sheet1", "Sheet3"))
Then, I have a second question,
You can store the macro in your personal.xls file but for only 10 workbooks
I think I add the macro to each workbook


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Metallo" wrote in message ...
Hi,

I have a workbook that contains 15 worksheets and I want to create 2 macros that apply a different formatting to 10 of the
worksheets only.
I created 2 buttons in a Macro sheet added to the WorkBook and when I have clicked the buttons they do apply the formatting to all
the 15 worksheets plus the macro sheet as well.
I presume this is due to the fact that I recorder the macro to be applied to this specific workbook, but I cannot find a
possibility to apply it only to specific worksheets.

Then, I have a second question, what's the best way to apply the same macro to 10 additional workbooks who only differ from the
one described because have different values?

Thank you
Alex