Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-06-2015, 05:09 AM
mrlemmer11 mrlemmer11 is offline on comment change/delete command? Windows 7 32bit on comment change/delete command? Office 2010 32bit
Novice
on comment change/delete command?
 
Join Date: Jun 2015
Posts: 13
mrlemmer11 is on a distinguished road
Default on comment change/delete command?


Hi there,

I would like to run some code prior to a user deleting a comment. Is there a way I can have VBA recognize when a user is attempting to delete any comment?

Thanks
Reply With Quote
  #2  
Old 07-06-2015, 09:10 PM
macropod's Avatar
macropod macropod is offline on comment change/delete command? Windows 7 64bit on comment change/delete command? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Word doesn't have any comment-based events you could tap into for this, so the most you might be able to do is to leverage the WindowSelectionChange event, but even that's limited to tapping into actual selection changes - typing over a comment or pressing the Delete button would be outside its scope.

For more info, see: http://word.mvps.org/FAQs/MacrosVBA/AppClassEvents.htm
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Code in a UserForm module to delete a Command Button which opens the userform Simoninparis Word VBA 2 09-21-2014 03:50 AM
MS Project -How to delete Change Working Time - For Calender erikmar Project 11 09-05-2014 03:44 AM
on comment change/delete command? create a new short cut key - insert and delete comment ubns Word 4 05-30-2012 12:04 AM
on comment change/delete command? How to insert a (balloon) comment and how to disable comment feature in Word2007? pstein Word 2 03-31-2012 05:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:41 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