I hope y'all can help me out with this problem. I am working on programming an Excel spreadsheet with the HeaderFooter procedure. This is how the code looks:
'Procedure to customize the header and footer
'Inserts the filename in the header
Worksheets("January 2003").PageSetup.CenterHeader = "&F"
'Declares the variable LeftFooterText as a string
Dim LeftFooterText As String
'Prompts user for left footer text
LeftFooter = InputBox("Enter your full name:")
'Inserts response into left footer
Worksheets("January 2003").PageSetup.LeftFooter = LeftFooterText
Worksheets("January 2003").PageSetup.CenterFooter = ""
'Inserts the date into right footer
Worksheets("January 2003").PageSetup.RightFooter = "&D"
My problem is that I can't seem to get my name to display on the left-side footer of the spreadsheet in Print Preview. Anybody got a clue as to what could be wrong with the code?
Thanks in advance,
Madison Area Technical College student
Go there. I have a lot of awesome photos that I rendered myself