Thread: Time Stamp
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DAI DAI is offline
external usenet poster
 
Posts: 8
Default Time Stamp

Hello,

I have created a macro to give me start and finish times with the click of a
button,

Function my_now()
Application.Volatile (False)
my_now = Now
End Function

However every now and the all entries are recalculated. (It only happens when
im not looking)

I was under the impression that with the (Application.Volatile (False)) this
could not happen.

Any ideas would be welcome.