Macro to Modify Another Macro

  • Thread starter Thread starter John
  • Start date Start date
J

John

I need to comment out a line in a macro that appears in
several hundred woorkbooks. Can I write a macro that will
do this? How?

I don't mind doing this one workbook at a time. In other
words, when an unmodified workbook is opened, the user
could run a macro that would make the appropriate
modifications.
 
I need to comment out a line in a macro that appears in
several hundred woorkbooks. Can I write a macro that will
do this? How?

I don't mind doing this one workbook at a time. In other
words, when an unmodified workbook is opened, the user
could run a macro that would make the appropriate
modifications.
Click to expand...

I suggest taking a look at Chip Pearson's site. Specifically:

http://www.cpearson.com/excel/vbe.htm
 
John,

There's some 'search replace code' on my website which could assist you with
this task.
 
Back
Top