selecting text by color

[tammy]

I need to select certain text using VBA and without
actually opening the doc or bringing it "into view". The
doc is based on a template and the tracking is on so that
any changes made are in red. I need a way to select this
text and change it to black. Is there a function related
to the document tracking, or a way to select just the red
text, or would it be better to select the full doc and
change the entire doc to black???

Thank you for any input!

 

[Theo van der Ster]

I need to select certain text using VBA and without
actually opening the doc or bringing it "into view". The
doc is based on a template and the tracking is on so that
any changes made are in red. I need a way to select this
text and change it to black. Is there a function related
to the document tracking, or a way to select just the red
text, or would it be better to select the full doc and
change the entire doc to black???

Thank you for any input!

Hi Tammy,

You can start with:
Application.ScreenUpdating = False
to prevent the user from seeing you opening the doc. Then open the doc
and do a search and replace. Just record it once and then copy & paste
the resulting code.

If you don't need to keep tracking the changes, you can also accept
them all. That would change the color back to black too.

Regards,
Theo