I need the right syntax to* prevent* the Spell Check dialog from showin
when it otherwise would upon encountering a wrong word. In suc
instance, I will rather prefer (to meet a special need ) to have a
Msgbox displayed simply indicating there is a "problem". I tried th
following code and failed, with the Speller dialog popping up each tim
... 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
Davi
--
david
-----------------------------------------------------------------------
davidm's Profile:
http://www.excelforum.com/member.php...fo&userid=2064
View this thread:
http://www.excelforum.com/showthread.php?threadid=47882