macro to change all worksheets

[tango]

hi,
i have a simple macro to do find and replace but only on the sheet that i open.
may i know how to make this macro to change all sheets if found the same string in the workbook?

sub macro()
Cells.Replace What:="C:\xxx\xxx\xxx\", Replacement:="C:\yyy\yyy\yyy\" _
, LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat _
:=False, ReplaceFormat:=False
end sub

thanks

[mudraker]

Please take a couple of minutes and read ALL the Forum Rules

You have previosly been asked to obey forum rules

Thread closed