My code is incredibly simple (below). All I want is to update cell D2 whenever someone saves the file (regardless of if they use save or save as). Currently, the code will work if I use save, but if I save as, then I need to go back into the code and hit enter or any key, and it will work again until I use save as again. This code is in the "ThisWorkbook" section.
Please Login or Register to view this content.
In case it matters, D2 is a formula: =LastSaved() which is run off a different code in the Module area:
Please Login or Register to view this content.
Bookmarks