Hi All
Thanks to Dave Hawley for previous code. I now have the following but would like to embolden the text in the header/footer:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Target.Address = "$A$1" Then
ActiveSheet.PageSetup.CenterFooter = Range("A1")
As a complete novice, the Microsoft VB Help File does not seem overly helpful. I have managed to glean that &B should turn bold on but where in the code does it go????
Ta very much
Cheers - Paul
Thanks to Dave Hawley for previous code. I now have the following but would like to embolden the text in the header/footer:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Target.Address = "$A$1" Then
ActiveSheet.PageSetup.CenterFooter = Range("A1")
As a complete novice, the Microsoft VB Help File does not seem overly helpful. I have managed to glean that &B should turn bold on but where in the code does it go????
Ta very much
Cheers - Paul