Is there a way to show who opened the file in the header section or just show who open the file?
P pgarcia Aug 18, 2008 #1 Is there a way to show who opened the file in the header section or just show who open the file?
G Gary''s Student Aug 18, 2008 #2 Put this macro in the workbook code area: Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.CenterHeader = Environ("username") End Sub
Put this macro in the workbook code area: Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.CenterHeader = Environ("username") End Sub
