Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-08-2024, 07:49 AM
ctviggen ctviggen is offline Simple macro recorded from recorder doesn't work to enable spell checking in single document Windows 10 Simple macro recorded from recorder doesn't work to enable spell checking in single document Office 2016
Advanced Beginner
Simple macro recorded from recorder doesn't work to enable spell checking in single document
 
Join Date: Feb 2021
Posts: 54
ctviggen is on a distinguished road
Default Simple macro recorded from recorder doesn't work to enable spell checking in single document

Word options, proofing, has exceptions for a single document that "hide spelling errors in this document only" and "hide grammar errors in this document only".




I ran the macro recorder on a document where both those were checked, so I unchecked them. I then saved the macro and copied it to a dotm file where I have a bunch of saved macros.



What I normally do is select the document (e.g., put the cursor in that document), then run a macro from the dotm file. This does not work for this particular macro:


Code:
Sub TurnOnSpellCheckforThisDocument()
'
' TurnOnSpellCheckforThisDocument Macro
' Ensures that spell check is enabled (not disabled) for this document
'
    ActiveDocument.ShowGrammaticalErrors = False
    ActiveDocument.ShowSpellingErrors = False
End Sub
Is the macro wrong? Or is there something I'm missing? Thank you.
Reply With Quote
  #2  
Old 01-08-2024, 09:50 AM
vivka vivka is offline Simple macro recorded from recorder doesn't work to enable spell checking in single document Windows 7 64bit Simple macro recorded from recorder doesn't work to enable spell checking in single document Office 2016
Competent Performer
 
Join Date: Jul 2023
Posts: 227
vivka is on a distinguished road
Default

Hi! My logic is prompting me that errors will be visible and, thus, able to be corrected only if all instances of False in the code are replaced with True,
Reply With Quote
  #3  
Old 01-08-2024, 10:21 AM
ctviggen ctviggen is offline Simple macro recorded from recorder doesn't work to enable spell checking in single document Windows 10 Simple macro recorded from recorder doesn't work to enable spell checking in single document Office 2016
Advanced Beginner
Simple macro recorded from recorder doesn't work to enable spell checking in single document
 
Join Date: Feb 2021
Posts: 54
ctviggen is on a distinguished road
Default

You are correct! Changing "false" to "true" works perfectly. Thank you.


Ugh...I must not have performed the macro recording correctly. Operator error!
Reply With Quote
  #4  
Old 01-08-2024, 10:41 AM
vivka vivka is offline Simple macro recorded from recorder doesn't work to enable spell checking in single document Windows 7 64bit Simple macro recorded from recorder doesn't work to enable spell checking in single document Office 2016
Competent Performer
 
Join Date: Jul 2023
Posts: 227
vivka is on a distinguished road
Default

You are welcome!
Reply With Quote
  #5  
Old 01-10-2024, 09:18 AM
Charles Kenyon Charles Kenyon is offline Simple macro recorded from recorder doesn't work to enable spell checking in single document Windows 11 Simple macro recorded from recorder doesn't work to enable spell checking in single document Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

See also: Keyboard Shortcuts to change "no proofing" status in Microsoft Word which has a macro linked to a keyboard shortcut to change the "Do not check spelling or grammar" setting for all text in a document to "false" (which is the setting needed to enable spelling check for that text).
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Modify recorded macro to run until end of document peter961 Word VBA 1 09-04-2017 02:50 PM
Spell check macro within macro button field doesn't work in one document samuelle Word VBA 0 07-20-2016 02:27 AM
Simple macro recorded from recorder doesn't work to enable spell checking in single document Italian Spell and Grammar check doesn't work fionnymy Word 16 04-03-2013 02:39 AM
Spell check checking only part of document Adeyo Word 1 02-24-2013 10:49 PM
simple code doesn't work help piper7971 PowerPoint 2 08-19-2010 08:15 AM

Other Forums: Access Forums

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