Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-12-2022, 06:32 PM
bronco9588 bronco9588 is offline Error Code when Running Macro with active comment Windows 10 Error Code when Running Macro with active comment Office 2019
Novice
Error Code when Running Macro with active comment
 
Join Date: Dec 2022
Posts: 4
bronco9588 is on a distinguished road
Default



Quote:
Originally Posted by Guessed View Post
I don't have a solution for you but will add a little explanation for others to think about.

There is a new behaviour of comments which appears in Word 365 but not in earlier versions. Now it appears that you can 'add' a comment via the GUI but until it is posted by clicking the button or pressing Ctrl-Enter then Word stores it in some intermediate mode which isn't a comment (according to VBA) although it shows alongside other comments in the comments pane. If you then try to add another new comment, the cursor returns to the un-submitted comment and won't allow new comments until you either post or delete that one. This behaviour is very annoying and not how the earlier versions of Word handled comments. I presume this is the problem that bronco9588 is trying to solve.

Recording a macro of adding comments shows that a comment gets 'added' only after it is posted and an unposted comment doesn't get recorded as an action. The unposted comment appears with the other comments but doesn't get included in the document's comment collection in VBA.
Yes, that is spot on. What I would like my macro to do is post that comment and return to the body of my document so the rest of my macros can run.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Error Code when Running Macro with active comment Change active cell after running macro in active cell via selection change Peterson Excel Programming 3 03-07-2021 12:19 PM
Error with macro to delete starting #) [code included] puff Word VBA 1 04-18-2018 03:49 PM
VBA Code for Printing Active worksheet .. LearnerExcel Excel Programming 1 02-11-2018 01:37 AM
Error 5941 when running my macro to auto populate fields throughout the word doc VBAnovice1 Word VBA 2 05-26-2015 01:35 AM
Error Code when Running Macro with active comment VB Code in Excel Active worksheet shakilhyd Excel 2 05-17-2010 07:50 AM

Other Forums: Access Forums

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


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