hi,
I got a number of sheets in my file.
In one of the sheet - I got a private sub worksheet_change(byval target as range), to capture timestamp.
I also got a "All Clear" macro in a module.
"All Clear" - marco clear all the cell value which user fill in the sheet.
The issue I am having is when I run "All Clear" macro after that the private sub stop working.
I have to close the file and open it again and it works file.
I was thinking if there is a way to call "private sub worksheet_change(byval target as range)" written in a sheet from a Macro written in a Module.
Hope someone can help.
Thanks
Saurabh