Function to run when Workbook opens

Hi all!

I need this function to work (to display the date/time sheet was last saved) everytime I open the Workbook.
The function works but only after I go to the cell where it is located and hit enter.

Please Login or Register  to view this content.

Thanks for any assistance.

put this is the "ThisWorkbook" code sheet.

Please Login or Register  to view this content.

Thanks very much.

Sorry not to get back to you sooner ... been out of town.
I right-clicked on ThisWorkbook and inserted a module end entered the code.
The LastSavedTimeStamp does not update until I go to the cell listing the function and hit enter.
I have made a slight change to the sheet and saved it. Closed the workbook and reopened it. Still no luck for the function to run automatically.
Any other ideas? Thanks!

try using a range instead, like so

Please Login or Register  to view this content.

Thanks again.
Using the Range worked, but not exactly like you did it with the ".Formula".
Rather:

Please Login or Register  to view this content.

Couldn't have done it without you, I am grateful. I'm sure this will help others also.
Have a good day!

Thanks Don. The "Range" made it work so I won't need to use Volatile.