Thread: Open by
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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?