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

[2BOYS4GRANNY]

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.

 

[Gord Dibben]

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