Open by
 

Is there a way to show who opened the file in the header section or just show
who open the file?

Open by
 

Put this macro in the workbook code area:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.CenterHeader = Environ("username")
End Sub

--
Gary''s Student - gsnu200800


"pgarcia" wrote:

Is there a way to show who opened the file in the header section or just show
who open the file?

Open by
 

You the man!

Question, how does it know where to get this info from?

"Gary''s Student" wrote:

Put this macro in the workbook code area:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.CenterHeader = Environ("username")
End Sub

--
Gary''s Student - gsnu200800


"pgarcia" wrote:

Is there a way to show who opened the file in the header section or just show
who open the file?