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
You cannot undo changes carried out by a macro.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Sorry MD but you might need to look at this from Jan Karel Pieterse
http://www.dailydoseofexcel.com/arch...utine-for-vba/
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
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
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Sometimes you need to cut & shut a question MD
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
so...what the solution for me?
can someone provide me a macro for that?
thanks
A solution is proposed in Post #3. I've not tried it, but suggest that as a starting place.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
unfortunately i'm not an IT, so i don't understand about code.
btw thanks for your help
Posting Permissions
Reply With Quote
