Spell check macro within macro button field doesn't work in one document

samuelle · #1 07-20-2016, 02:27 AM

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.

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
Tying a check box to a macro/VBA to customize a document	mhblake	Word VBA	3	12-04-2013 04:17 PM
Italian Spell and Grammar check doesn't work	fionnymy	Word	16	04-03-2013 02:39 AM
Assign macro but hide the button/field	trlear	Word VBA	5	02-23-2012 04:35 PM
Word Macro That Checks a Check Box Form Field When File Print is Executed	DKerne	Word VBA	4	06-09-2011 11:54 AM