Hey fellas,

I have a macro-enabled workbook, which means the undo button is greyed out. I need the undo button. So I figure the best solution is to copy the worksheet to a hidden one for each change made, and then make the undo button show that saved worksheet. I'm not real sure on the syntax of saving copies of worksheets to hidden ones for this purpose. Any ideas, VBA community?