Hi Ankur, VBA/VSTO Macro Programming don't provide undo of automated tasks. Application.undo works for manual tasks only where it saves the last state of opened workbooks in application.
But still we're working on this issue and future versions you'll find that this problem is solved with certain limitations. Regards Ashish Jain www.excelitems.com Developer of Open XL --------------------------------------------------------------------------------------------------- On Apr 28, 11:48 am, Ankur Satija <[email protected]> wrote: > One problem using Open XL... > > Once any function in OpenXL is used it can't be undone using Ctr+Z . > > Plz solve this querry.... > > > > > > On Mon, Apr 27, 2009 at 6:57 PM, Ashish Jain <[email protected]> wrote: > > > If you want to do any or all of the following. Visit > >http://www.excelitems.com > > and Download Open XL. > > > 1. Run Charts Slideshow > > 2. Calculate Business Working Days > > > 3. Sort Worksheets > > 4. Merge Worksheets > > 5. Superhide a worksheet > > > 6. Copy Multiple Selections > > 7. Learn VBA/VSTO > > > 8. Copy Worksheets to MS Word > > 9. Invert the Selection > > > 10. Remove all Empty Rows > > 11. Delete Blank Sheets > > > and run such 125 utilities from single addin. Open XL is a freeware > > addin. > > Download, Install and Use. > > > This is definitely gonna save your lots of hours. Enjoy Excel ! > > > Regards > > Ashish Jain > >www.excelitems.com > > Developer of Open XL > > -- > Ankur Satija, Consultant > GRID - Energy, Utilities & Mining > PricewaterhouseCoopers Private Ltd. Building 8, Tower B, Floor 8| DLF Cyber > City, Gurgaon - 122022 | Haryana, India > Mobile: +91 9871041757 > Email: [email protected] Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] If you find any spam message in the group, please send an email to: Ayush Jain @ [email protected] or Ashish Jain @ [email protected] ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
