VBA macro to change author name in tagged comments, then delete the tags
I would like to automate changes to the author name in comment bubbles. As an example, when the macro is run, every comment bubble that already has the word "goat" in it (case insensitive) would be changed to the author name "Sheep" and then all the tags would be automatically deleted. Ideally, the macro would work regardless of where the cursor is (in the main document or in the comment bubbles) at the time. Besides being case insensitive for matching, it would be good for the macro to match the tag word regardless of whether it is followed by a space, and also to replace the tag word and line break if it is followed by a line break. Any help would be much appreciated, as I am ignorant of coding!
|