Paul,
Thanks a ton. I will verify this code and get back to you
Regards,
Karthik
On Thu, Feb 4, 2016 at 7:54 PM, Paul Schreiner
wrote:
> I threw this together from some macros I created several years ago.
> I tested it and cleaned it up a bit.
>
> To insert it into your VBproject:
> save it to
I threw this together from some macros I created several years ago.I tested it
and cleaned it up a bit.
To insert it into your VBproject:save it to a folder.change the file extension
from ".b" to ".bas"
you should be able to double-click the file,or go into the vbeditor,
right-click in the "modu
>
> Do you have more than 1 macro ? Why don't you paste the code in notepad
> and simply replace Msgbox with 'Msgbox and paste it in vba module.
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Faceb
Thank you Paul for quick reply,
Your understanding of my requirement is correct. For easy understand of the
requirement i said msgbox code need to be comment out, where as in my
actual macro their are couple of macro lines to be comment out. If you tell
me the way to comment one line of code, i ca
I take it you are trying to say that you want to "comment out" the Msgbox line?
One solution would be to:Export the macro moduleUse Textstream Object to edit
the exported ascii file.Remove the macro moduleImport the edited module.
Now, this would only work on "standard" modules.Because I don't th
