Create and Run Spellcheck Macro on Restricted (protected) Form

Hi All!

I have a form I created that is restricted to filling in fields.  Because spellcheck will not check fields in a protected form, I would like to create a macro that will do the following:  1) stop protecting the form 2) run spellcheck and then; 3) protect the form.  

I am haven't been able to figure out how to do this since the "record macro" button is grayed out when the document is protected.  If I unprotect the form to begin recording the macro, I loose the step of unprotecting the form in the actual macro recording.

A few years back I was able to get this to work in a protected Excel Spreadsheet.  Can I not do this in Word?

Sincerely,

Amy

Answer
Answer

See the following page of fellow MVP Graham Mayor's website:

http://www.gmayor.com/installing_macro.htm

However, unless your form is going to be used by users who only have Word 97-2003, you may be better off to use Content Controls, which do not require that protection be applied to the document.

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Answer
Answer
There's a macro at http://word.mvps.org/FAQs/MacrosVBA/SpellcheckProtectDoc.htm that should do what you want.
Microsoft MVP (Word) since 1999
Fairhope, Alabama USA
http://ssbarnhill.com
http://wordfaqs.ssbarnhill.com
Screen shots captured with TechSmith's Snagit

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated October 5, 2021 Views 970 Applies to: