Forum Discussion

ExcelExciting's avatar
ExcelExciting
MVP
May 19, 2022

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.

  • graceo's avatar
    graceo
    Copper Contributor
    May 19, 2022

    ExcelExciting 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 🙂 

    • ExcelExciting's avatar
      ExcelExciting
      MVP
      May 20, 2022

      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.

Resources