PDA

View Full Version : Solved: Tracking changes with comments



reza_doang
06-10-2010, 12:30 AM
Hi All,

i read an article about tracking changes in this link:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=909
the code works perfect, but why i can use undo feature.

can the experts change a little code, so excel can still use undo feature.

many thanks

regards,

reza

mdmackillop
06-10-2010, 01:37 PM
You cannot undo changes carried out by a macro.

Aussiebear
06-12-2010, 04:18 PM
Sorry MD but you might need to look at this from Jan Karel Pieterse

http://www.dailydoseofexcel.com/archives/2005/08/29/generic-undo-routine-for-vba/

mdmackillop
06-13-2010, 04:50 AM
Hi Ted,
Does that fit within the "change a little code" parameter? Of course nothing is impossible. You could also use SaveCopyAs after every change. Might slow things down a bit, but you could recover to an earlier stage.
Regards
Malcolm

Aussiebear
06-13-2010, 11:02 PM
Sometimes you need to cut & shut a question MD :devil2:

reza_doang
06-14-2010, 09:01 PM
so...what the solution for me?
can someone provide me a macro for that?

thanks

mdmackillop
06-14-2010, 10:39 PM
A solution is proposed in Post #3. I've not tried it, but suggest that as a starting place.

reza_doang
06-14-2010, 11:30 PM
unfortunately i'm not an IT, so i don't understand about code.
btw thanks for your help