Macro to Modify Another Macro

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.
 
H

Hank Scorpio

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
 
R

Rob van Gelder

John,

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