Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-20-2016, 02:27 AM
samuelle samuelle is offline Spell check macro within macro button field doesn't work in one document Windows 7 32bit Spell check macro within macro button field doesn't work in one document Office 2010 32bit
Novice
Spell check macro within macro button field doesn't work in one document
 
Join Date: Jul 2016
Posts: 2
samuelle is on a distinguished road
Default Spell check macro within macro button field doesn't work in one document

Hi,

I am using the following macro to allow spell check on a protected Word form. In one Word form, inserting a form field Macrobutton so the user can click on this to spell check the form works absolutely fine.

Code:
Sub SCForm()
   ActiveDocument.Unprotect
   Selection.WholeStory
   Selection.LanguageID = wdEnglishUS
   ActiveDocument.CheckSpelling
   ActiveDocument.Protect Type:=wdAllowOnlyFormFields, NoReset:=True
End Sub
I then used Alt-F9 then Ctrl-F9 to insert a field and filled in as below:
Code:
{ MACROBUTTON SCForm Please click here to spell check }
This works in one document, but in a second, longer form when clicked it simply jumps the cursor to the first form field and does nothing else. I tried copying and pasting it, starting a new document, but only ever works when there are fewer overall fields. I have check macros are enabled.

The macro itself will run in all documents via the VB Editor, it only doesn't run from the macro button. The macro itself is stored in Normal>Modules>NewMacros - I have checked the drop down to see if there are more options but it only says (General). I am pulling my hair out! Any ideas gratefully received.
Reply With Quote
Reply

Tags
macro, spellcheck, userform

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro (or something) to run Spell Check within rich text content boxes in lock document NMBELL Word 8 12-21-2015 04:09 PM
Spell check macro within macro button field doesn't work in one document Tying a check box to a macro/VBA to customize a document mhblake Word VBA 3 12-04-2013 04:17 PM
Spell check macro within macro button field doesn't work in one document Italian Spell and Grammar check doesn't work fionnymy Word 16 04-03-2013 02:39 AM
Spell check macro within macro button field doesn't work in one document Assign macro but hide the button/field trlear Word VBA 5 02-23-2012 04:35 PM
Spell check macro within macro button field doesn't work in one document Word Macro That Checks a Check Box Form Field When File Print is Executed DKerne Word VBA 4 06-09-2011 11:54 AM

Other Forums: Access Forums

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