Forum Discussion
awbenson
Jun 23, 2023Copper Contributor
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 ...
JKPieterse
Jun 23, 2023Silver Contributor
The date and time should stay put. Is anything in your other VBA code making changes to the sheet when it is opened?
awbenson
Jun 23, 2023Copper Contributor
I have no other VBA code running, so something has to be happening behind the scenes when I open a file that I'm unaware of.