Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-28-2021, 08:48 AM
mjt mjt is offline VBA macro to change author name in tagged comments, then delete the tags Windows 10 VBA macro to change author name in tagged comments, then delete the tags Office 2019
Novice
VBA macro to change author name in tagged comments, then delete the tags
 
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
Reply

Tags
author, comments, macro

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a macro or Find/Replace Code to delete tags bonzai217 Word 2 08-04-2019 08:36 AM
Turning off comments from individual author only mikkelgivskov@gmail.com Word 1 08-27-2016 09:41 PM
VBA macro to change author name in tagged comments, then delete the tags Word macro to change style between tags superxl Word VBA 1 05-15-2016 03:17 PM
VBA macro to change author name in tagged comments, then delete the tags Why have all of my authors been replaced with the generic "author" in comments? CanvasShoes Word 1 02-01-2013 01:32 PM
Automated "Macro" to delete Tags/Anchors field3 Word VBA 0 02-25-2009 02:53 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:46 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft