on my schedule file, every time before save the file, i need to change the time to let other people know that data is updated. can excel have a formula auto change the file on every time i pressing the save button ?
on my schedule file, every time before save the file, i need to change the time to let other people know that data is updated. can excel have a formula auto change the file on every time i pressing the save button ?
Last edited by choy96; 11-04-2010 at 09:49 AM.
Right click on the tab and then double click on "This Workbook" and paste this code into the Editor
replacing sheet1 with your sheet name and A2 with where you want the date and time to be. Does that help?Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Great and thanks !
can i have the time is adding 2 or 3 hours to the current time ?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks