Re: $$Excel-Macros$$ Deleting modules

2011-11-23 Thread Chandra Shekar
Thanks all :) Regards, Chandra Shekar B On Tue, Nov 22, 2011 at 9:38 AM, xlstime wrote: > hi chandra, > > > please find the below code for remove module .. > > http://www.ozgrid.com/VBA/delete-module.htm > Sub DeleteThisModule() > > Dim vbCom As Object > > > Set vbCom = Application.VBE.Act

Re: $$Excel-Macros$$ Deleting modules

2011-11-22 Thread xlstime
hi chandra, please find the below code for remove module .. http://www.ozgrid.com/VBA/delete-module.htm Sub DeleteThisModule() Dim vbCom As Object Set vbCom = Application.VBE.ActiveVBProject.VBComponents vbCom.Remove VBComponent:= _ vbCom.Item("Module1") End Sub On Tue, Nov

Re: $$Excel-Macros$$ Deleting modules

2011-11-21 Thread Chandra Shekar
Hello, Thanks for the reply. can we write code for this & assign to a button. Regards, Chandra Shekar B On Mon, Nov 21, 2011 at 3:19 AM, Venkat CV wrote: > Hi Chandra Sekar, > > Right Click on Module and Remove module and Click option No,, > > *Best Regards,* > *Venkat * > *Chennai* > *My Link

Re: $$Excel-Macros$$ Deleting modules

2011-11-20 Thread Venkat CV
Hi Chandra Sekar, Right Click on Module and Remove module and Click option No,, *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Fri, Nov 18, 2011 at 4:23 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello, > > Cou

Re: $$Excel-Macros$$ Deleting modules

2011-11-18 Thread NOORAIN ANSARI
Dear Shekhar, try this Step.. Select Module-Right click-Remove Module-Press No On Fri, Nov 18, 2011 at 4:23 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello, > > Could you please let me know how to delete module? > > Thanks in advance. > > > > Regards, > > Chandra Shekar B > > -