View Single Post
 
Old 01-28-2021, 08:48 AM
mjt mjt is offline Windows 10 Office 2019
Novice
 
Join Date: Jan 2021
Posts: 1
mjt is on a distinguished road
Default 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!
Reply With Quote