command button- spell check

[graceo]

how do you create a spell check command button in excel?

[#2]

Hi @graceo,

What I feel you should add a spellcheck button to the quick access toolbar rather than creating a macro button as this will help you to access spellcheck on any of your workbooks open on your system.

Regards, Faraz Shaikh | Microsoft MVP, MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget to mark it as the Official/Best Answer & like it to help the other members find it more.

[#3]

@Faraz Shaikh thanks for your response, this is a report for others that goes to owners, it would be easier for them if the button was on the form to help them not to forget to spell check :) 

[#4]

hi @graceo 

You can use the below code and paste it to the module and then assign it to button.

Sub SpellCheck()

    Cells.CheckSpelling IgnoreUppercase:=False, AlwaysSuggest:=True
    
End Sub

I would suggest you also to paste this code before workbook is close, it would great incase if the users forget to do the spellcheck.

Regards, Faraz Shaikh | Microsoft MVP, MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget to mark it as the Official/Best Answer & like it to help the other members find it more.