Hello,
I have a tracker that I user to timestamp tasks. This tracker has a macro timestamp and VBA that runs when specific criteria is met (such as spell check and when saving the document).
If I open the tracker and activate any of the VBA they work fine, as soon as I use the timestamp all the VBA stops working and I cannot work out why.
I have attached a copy of the tracker.
Thanking you in advance.
You have a major flaw in your Worksheet_Change event codes. You disable events, then check if the changed cell was in column E. If it wasn't, you then exit the routine but you don't re-enable events. You should move the code that disables events so that it comes after the column E check.
Rory
Hi Rory, thanks for the feedback. I have made the corrections and it all appears to be working fine n dandy. THANK YOU....
Glad to help, and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks