samsilverman
Board Regular
- Joined
- Nov 9, 2009
- Messages
- 176
I am using Excel 2007.
I currently have a code in each of 3 worksheet modules. They are all slightly different, but basically they change the Worksheet Header when an action is initiated. Here is an example:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 5 Then
ActiveSheet.PageSetup.CenterHeader = "&""Calibri""&B&18TEST AREAS " & Chr(10) & Sheet1.Range("C5")
End If
End Sub
What I want to do is change the Worksheet Headers for WorkSheets 1, 2 and 3 based on a cell selection or cell change in WorkSheet1. Is this possible?
Each WorkSheet's Header would have different info, but all three would use the same font/formatting as the code indicates above. Part of the info for each header would include a reference to Sheet1, cell C5.
Thanks
Thank you.
I currently have a code in each of 3 worksheet modules. They are all slightly different, but basically they change the Worksheet Header when an action is initiated. Here is an example:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 5 Then
ActiveSheet.PageSetup.CenterHeader = "&""Calibri""&B&18TEST AREAS " & Chr(10) & Sheet1.Range("C5")
End If
End Sub
What I want to do is change the Worksheet Headers for WorkSheets 1, 2 and 3 based on a cell selection or cell change in WorkSheet1. Is this possible?
Each WorkSheet's Header would have different info, but all three would use the same font/formatting as the code indicates above. Part of the info for each header would include a reference to Sheet1, cell C5.
Thanks
Thank you.