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