In my attached worksheet, I have code (copied from some thread somewhere) that does just what I want, except that Undo doesn't work any longer.
I think Application.EnableEvents=False is the culprit.
Is there a simple way around this?
The only thing I can think of is to capture the Undo Event, and then figure out how to programmatically Undo what the user just did.
Thanks!
Running any code will 'cancel' Undo.
If posting code please use code tags, see here.
When VBA writes to the same sheet, it cancels the undo. One way around that is to log the time values to another sheet.
If you want to have the time value show in the original sheet as well, put a formula like this in Cell H1 and copy down and across. Format H1 as Date-time
Please Login or Register to view this content.
=IF(Sheet2!A1="","",Sheet2!A1)
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thank you. That worked great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks