Before Print Problem
Hi,
Thank you for the suggestion, Tim. It was a great idea. My immediate
window shows the code executing and returns the correct Header, but the
printed copy still shows the old header.
Here are the results from my immediate window...
Starting BeforePrint, HdrVal = &C&14&BDayna's Mall&4
&12&A
&C&14&BDayna's Mall&4
&12&A
--
Thanks for your help.
Karen53
"Tim Zych" wrote:
Try assigning it to a variable so the string can be fully resolved before it
goes into the header, e.g.
Dim HdrVal As String
HdrVal = "&C&14&B" & SumbyLineItempg.Range("E2").Value & _
"&4" & vbCrLf & "&12&A" & vbCrLf & " "
Debug.Print HdrVal
.CenterHeader = HdrVal
Then you can inspect it too to help narrow down the problem.
--
Tim Zych
SF, CA
"Karen53" wrote in message
...
Hi,
I have the following BeforePrint routine in my ThisWorkbook module which
places a custom header on pages based on the value of cells in the sheet.
It
worked except now if the value of the cell changes, it is not picking up
the
change and stays with the old value in the header. This there something
I
am missing?
Private Sub Workbook_BeforePrint(Cancel As Boolean)
'add custom header to pages before printing
With SumbyLineItempg.PageSetup
.CenterHeader = "&C&14&B" & SumbyLineItempg.Range("E2").Value & _
"&4" & vbCrLf & "&12&A" & vbCrLf & " "
End With
With LineItemspg.PageSetup
.CenterHeader = "&C&14&B" & LineItemspg.Range("C2").Value & _
"&4" & vbCrLf & "&12&A" & vbCrLf & " "
End With
With MainPagepg.PageSetup
.CenterHeader = "&C&14&B" & MainPagepg.Range("B1").Value & _
"&4" & vbCrLf & "&12&A" & vbCrLf & " "
End With
End Sub
--
Thanks for your help.
Karen53
|