I need the right syntax to prevent the Spell Check dialog from showing when it otherwise would upon encountering a wrong word. In such instance, I will rather prefer (to meet a special need ) to have a Msgbox displayed simply indicating there is a "problem". I tried the following code and failed, with the Speller dialog popping up each time ... in spite of negating DisplayAlerts.
Sub SuppressSpeller()
Application.DisplayAlerts=False
x= Cells.CheckSpelling
If x =True then Msgbox "Spell error"
Application.DisplayAlerts=False
End Sub
TIA
David
Bookmarks