Forum Discussion
Date of Last Modification of a Worksheet
Hello all, I have been trying to workshop a VBA code block with ChatGPT to display the date in a particular cell whenever ANY change is made in the worksheet. Here is my code so far: Private ...
Even when I open your example file, it updates to the opening time. Clearly, there's some process updating the sheet/a cell happening when I open any Excel file, but am unaware of it. Thanks for trying, though! I have no other VBA code running.
The code works as described for me.
It is not changed when the file is opened, only when the change is made.
Have you updated?
A repair for this?
If this doesn't help, disable all AddInn and try again.
If this does not help either, start in safe mode and then test the function.
If not, I'm at my wits end.