How do I run code in a specific sheet only?

[blu112]

Let's say I have a Workbook with Sheets 1 to 10. I came up with the following and it works well enough since all the cells I want referenced are the same in each sheet. Except for Sheet 1.

If my Sheet 1 cells are a2, b2, and c2 instead, how do I set it up to only run in Sheet 1?

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
temp = Range("a1").Value
temp = temp & Chr(13) & Range("b1").Value
temp = temp & Chr(13) & "Week Ending" & " " & Range("c1").Value
ActiveSheet.PageSetup.CenterHeader = temp

End Sub

Ideally I want to adjust it so that when I press save in any sheet, it will run the macro through all the sheets. I still haven't figured out how to do that.

[ikboy]

Please Login or Register  to view this content.

[jindon]

Let's say I have a Workbook with Sheets 1 to 10. I came up with the following and it works well enough since all the cells I want referenced are the same in each sheet. Except for Sheet 1.

If my Sheet 1 cells are a2, b2, and c2 instead, how do I set it up to only run in Sheet 1?
Ideally I want to adjust it so that when I press save in any sheet, it will run the macro through all the sheets. I still haven't figured out how to do that.

See if this is how you wanted.

Please Login or Register  to view this content.

Edit; added ws. for each Range in array.

[blu112]

See if this is how you wanted.

Please Login or Register  to view this content.

Edit; added ws. for each Range in array.

This works perfectly. Thank you so much.

[jindon]

You are welcome and thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[Pepe Le Mokko]

Administrative Note:

Please don't quote entire posts unnecessarily. They clutter threads and make them hard to read.
Use the "Quick reply" instead
Thanks