Auto speel correction macro code

[MayHmne]

Hi
I need Auto speel correction macro code to chick and correct automatically and without asking

 

[JLGWhiz]

I agree, but I don't believe Excel has auto spellcheck and IMHO a macro would just duplicate the facility already available on the ribbon under 'Review'.
However, maybe this link will help you

How to Spell Check in Excel & VBA

This tutorial will demonstrate how to use spell check in Excel and in VBA. Spell Check in Excel Microsoft Excel offers a basic spelling function that can

www.automateexcel.com

 

[Michael M]

If you Click File > Options > Proofing, clear the Check spelling as you type box, and click OK. To turn spell check back on, repeat the process and select the Check spelling as you type box.
Rhen when you type a repeated word it will autosuggest....but otherwise, I don't believe there is another option

 

[MayHmne]

thank you all
I tried to repeatedly press the "Change all" option

 

[JLGWhiz]

thank you all
I tried to repeatedly press the "Change all" option

I believe the 'Change All' will only apply to selected cells. If you want to spell check in multiple cells, then select those cells that apply and then click the 'Change All' option.

 

[MayHmne]

Great, I'll consider that the next time
Thanks again