ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   worksheet last updated (https://www.excelbanter.com/excel-programming/308643-re-worksheet-last-updated.html)

Frank Kabel

worksheet last updated
 
Hi
Excel stores only the last save time (regardless which worksheet was
altered). So there's no build-in information for this. You'll have to
create a worksheet_change event and store this information on your own

--
Regards
Frank Kabel
Frankfurt, Germany

"Sheldon" schrieb im Newsbeitrag
...
How can I capture the date/time when a selected worksheet in a

workbook was
last modified and saved? If a different worksheet was modified and

the
worksheet saved, I'm not interested in that date/time.

thanks.




All times are GMT +1. The time now is 01:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com