=LastSaveTime()+Trunc(Rand())

Should make it volatile

--
Regards,
Tom Ogilvy


Ruan Walters wrote in message
...
Thanks Chip,

The only issue I have is that the function you gave me displays the
"Save Time" after I press <enter on "=LastSaveTiem()". After that the
cell doesn't refresh when I save the Workbook again. I have to manually
refresh that cell by editing it and pressing enter to get the Last Save
Time to change.

Am I doing something wrong? I created the Function inside the "Modules"
code window.

Thanks
Ruan



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!