View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
mike mike is offline
external usenet poster
 
Posts: 216
Default Worksheet_Change & Undo

Thanks, Pikus. John (above) has also pointed me to
another possible solution. This macro will actually be
executed very frequently.

Mike.

-----Original Message-----
Start the macro with:

ThisWorkbook.Save

It will take a few seconds, but you'll always be able to

revert to your
saved version from before the rest of the macro ran.

This won't be too
hot if the macro is run very often, and I'm sure there's

a more
effective answer, but this will do in a pinch. - Pikus


---
Message posted from http://www.ExcelForum.com/

.