JamesMitel
New Member
- Joined
- Apr 29, 2015
- Messages
- 2
Hello,
I have created a database in excel with multiple sheets with various functions and stored on OneDrive which allows others to see it.
What I require is for it to show the Time and Date it was last saved in a particular cell in a worksheet.
I have done various searchers across the net and tried multiple things using VB (Visual Basic) but have had no luck. A quick search on this forum showed me how to do the last time saved, but not both Time AND Date.
Another thing, will this macro continue to function if hosted on onedrive - I usually click 'open with Excel application' - but need others to see the date.
Help on this matter is greatly appreciated - I've been scratching my head for the past few days now!
I have created a database in excel with multiple sheets with various functions and stored on OneDrive which allows others to see it.
What I require is for it to show the Time and Date it was last saved in a particular cell in a worksheet.
I have done various searchers across the net and tried multiple things using VB (Visual Basic) but have had no luck. A quick search on this forum showed me how to do the last time saved, but not both Time AND Date.
Another thing, will this macro continue to function if hosted on onedrive - I usually click 'open with Excel application' - but need others to see the date.
Help on this matter is greatly appreciated - I've been scratching my head for the past few days now!