Compile error thisworkbook

[AlexPi]

I searched but could not find anything that helped...

I have a spreadsheet that is updated by more than one user so I put in the code below that will show who saved it last and when. The problem I am having is that this works fine on my computer but anyone else who clicks save gets a compile error thisworkbook...

Any ideas?

Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
 
 
 
Sheets("Overview").Range("K2").Value = Environ("username")
 
Sheets("Overview").Range("K1").Value = Date
 
 
End Sub

I'm also having trouble with another part of code that works on my computer but no one else can use it. I have a check box that locks a range of cells. Other users also get a compile error for this as well.
Thanks!

 

[Andrew Poulsom]

References are attached to the workbook, so I don't see why other users could have it checked for your workbook if you don't.

 

[AlexPi]

I was looking at the wrong template! I fixed the problem for good now. Thanks for all your help!

Alex