On 18 Mai, 16:10, Hiren Sheth <[email protected]> wrote: > Hi, > > Is it possible that a sub procedure will do certain steps and at the end it > will delete itself. > > Seems to be a strange question but is it possible?
It certainly seems so (see for example http://www.vbaexpress.com/kb/getarticle.php?kb_id=250). However, I encountered some problems with Excel 2003 when I tried to add code to a workbook that was opened in the same Excel application (Excel sometimes crashed with an Access Violation). This malfunction leads me to believe that code that deletes itself is very likely to crash Excel as well. To put it like some sportswear manufacturer: Just try it! Regards, Stuart PS: If you post to newsgroups, you can safely turn off your privacy disclaimer (after all, your posting is _supposed_ to be readable by everyone :-) -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
