Is there anyway to do the following...

Say I want to replace this

(name)

in every sheet with txtFirstName.value

for example

txtFirstName.value = "Bob"

So every sheet that has (name) in part of the cell will be replaced with Bob.

But when the worksheet closes put (name) back in and take out Bob.

thanks for any help

Josh