taking excel class want a macro with my name etc. to print on bott

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm taking a excel class and want to create a macro that will have my name
etc. printed on the bottom of each assignment I turn in. I thought I did it
right but when I go to print view it is not there.
 
If you posted the code someone could help with that.

Otherwise...........

Sub PathInFooter()
ActiveSheet.PageSetup.RightFooter = ActiveWorkbook.FullName & " " & _
ActiveSheet.Name & " " & Application.UserName & " " & Date
End Sub

Not sure what "etc." means so added a few things. Adjust to suit.


Gord Dibben Excel MVP
 
Back
Top