Delete VBA code in worksheet through a macro
 

VJ,

See www.cpearson.com/excel/vbe.htm


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"VJ" wrote in message
...
Hi

I want to delete the code in the worksheet through a VBA macro.
Can some pls suggest me a way out?

Thanks

Delete VBA code in worksheet through a macro
 

Chip Pearson wrote:

VJ,

See www.cpearson.com/excel/vbe.htm

Yes, and if you are using McAfee, you will notice that it is *very*
efficient at zapping your entire code module if you dare to use any of
these:
VBComponents.Add
VBComponents.Remove
VBComponents.Import
CodeModule.InsertLines
CodeModule.DeleteLines

as I have experienced to my great horror. Fortunately I always make
regular backups!

--
To top-post is human, to bottom-post and snip is sublime.