Hi,
Is it possible to change a cell value when the workbook is saved?
I have a 'last updated' cell with a date in it (H24) and when the user hits either save or save as (be nice if it worked for both)
I'd like this date to change to today's date.
Possible?
Gavin
Last edited by Gavin Ling; 02-06-2012 at 10:33 AM.
hi,
you can find a lot of examples here...but just try it and see if it helps you!
and
Please Login or Register to view this content.
Please Login or Register to view this content.
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
John, the workbook macro... you'll need to specify which worksheet gets that change on cell H24, too.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
OK so I'm a bit of a newbee...
I put this in the 'This Workbook':
..and it seems to work fine :-) ThanksPlease Login or Register to view this content.
hi JBeaucaire,
Thank you, yes, you're right!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks