Macro from "This Workbook" not working when opening document

[lojanica]

Hi all
I have the code below in "ThisWorkbook" which I want to run each time the document opens.

Private Sub Workbook_Open()

ThisWorkbook.Sheets("ActiveUser").Range("B6").Value = Environ("USERNAME")

End Sub

Can anyone help me understand why the code does not work when opening a document but does when I press Run Sub?

Thanks
Milan

 

[lojanica]

Do you have any other macros running , Event macros or otherwise ?
If you close the workbook and just before opening it again put this in the immediate window and hit enter

Application.EnableEvents = True

does it then work ?

It works!

Thanks for help

 

[Alex Blakenburg]

That means you have a macro that that turns it off and either doesn't have the line turning it back on again or is not running that line before exiting the macro either because it is crashing or because of some of the logic that bypasses it.