non macro timestamp

[Dscalf1]

Is there no way to create a timestamp in excel with out using a macro? I really need a timestamp but I have tried using a macro and it just isnt working its more headache than its worth.

 

[ParamRay]

Ctrl+Shift+: (colon)

 

[Eric W]

Enable Iterative Calculation (File > Options > Formulas > Enable Iterative Calculation), and format the date/time cell with a date/time format.

If your data is in A2, and you want the date/time in B2 when something is entered in A2, enter this formula in B2:

=IF(A2="","",IF(B2="",NOW(),B2))

The timestamp will be entered when you enter something in A2, and will remain static if you change other cells. It will change if you delete A2, and re-enter something in A2.

 

[My Aswer Is This]

Well I have used a time stamp using Excel macro for years and it always worked.
Tell us what your trying to do.

 

[Dscalf1]

Well I have used a time stamp using Excel macro for years and it always worked.
Tell us what your trying to do.

Private Sub Worksheet_Change(ByVal Target As Range)


 ActiveSheet.Unprotect "Bakery"
 
   If Not Intersect(Target, Range("R6:AF75")) Is Nothing Then
      Application.EnableEvents = False
      Cells(Target.Row, 60) = Now
      Application.EnableEvents = True
   ElseIf Not Intersect(Target, Range("AJ6:AX75")) Is Nothing Then
      Application.EnableEvents = False
      Cells(Target.Row, 62) = Now
      Application.EnableEvents = True
      
 ActiveSheet.Protect "Bakery", True, True
      
   End If
End Sub

I was using this but it works great on my computer and then when I move the file to my companies shared drive and try to use it on the computer i need it on it doesnt work im getting so frustrated and all my formulas seem to be working fine on that computer so i think that is more the route I want to go

 

[My Aswer Is This]

Well some companies do not allow users to use Excel Vba.
To use the script you have show has to be used on a Workbook that is Macro enabled.
So that may be the problem.

 

[Dscalf1]

Well some companies do not allow users to use Excel Vba.
To use the script you have show has to be used on a Workbook that is Macro enabled.
So that may be the problem.

Nope they are both macro enabled and both company computers but works on one and not on the other... its so weird Ive never seen anything like it