View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default Header and Footer Macro

You'd need to add a few lines of code at the top, something like this:

Dim UserName As String

Do Until UserName < ""
UserName = InputBox("Please enter your name: ", "INPUT REQUIRED")
Loop

and then change one of the footer lines (.LeftFooter, .CenterFooter,
..RightFooter) like this:
..RightFooter = "&Z&F" & " " & UserName