Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 150
Default Deleting code comments from modules

Hi,

While experimenting with various options, I have commented a lot of
code in various modules, Userforms, ThisWorkbook and Worksheets. I
have now finalised the code and wish to remove all comments including
the commented code. Doing this manually is a herculean task. Can I do
this programmatically?
(I can then add all the helpful comments manually)

Thanks in advance for all the help.

Regards,
Raj
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,588
Default Deleting code comments from modules

http://www.vbaexpress.com/kb/getarticle.php?kb_id=266

Tim

"Raj" wrote in message
...
Hi,

While experimenting with various options, I have commented a lot of
code in various modules, Userforms, ThisWorkbook and Worksheets. I
have now finalised the code and wish to remove all comments including
the commented code. Doing this manually is a herculean task. Can I do
this programmatically?
(I can then add all the helpful comments manually)

Thanks in advance for all the help.

Regards,
Raj



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 150
Default Deleting code comments from modules

On Feb 23, 6:58 am, Raj wrote:
Hi,

While experimenting with various options, I have commented a lot of
code in various modules, Userforms, ThisWorkbook and Worksheets. I
have now finalised the code and wish to remove all comments including
the commented code. Doing this manually is a herculean task. Can I do
this programmatically?
(I can then add all the helpful comments manually)

Thanks in advance for all the help.

Regards,
Raj


Hi,

I pasted the vbaexpress code in a new module, set the macro security
to allow access to VB Project and ran the code. It did not work. Is
there anything else I need to do to make this work.

TIA
Raj
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting modules in XLA ExcelMonkey[_190_] Excel Programming 2 February 27th 05 02:17 PM
When to code in sheet or userform modules and when to use modules Tony James Excel Programming 1 December 16th 04 10:02 PM
VBA extensibility library for deleting forms, modules, code etc... Ajit Excel Programming 2 November 19th 04 03:41 AM
VBA extensibility library for deleting forms, modules, code etc... Frank Kabel Excel Programming 0 November 18th 04 07:06 PM
No success deleting modules BrianG[_4_] Excel Programming 1 October 18th 03 07:24 PM


All times are GMT +1. The time now is 12:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"