Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I enable the spellchecker in a protected worksheet? | Excel Programming | |||
supressing a message in vba | Excel Programming | |||
How to invoke spellchecker in VBA to check a string? | Excel Programming | |||
ActiveXTextBox with SpellChecker ? | Excel Programming | |||
Using Excel Spellchecker On a Locked sheet | Excel Programming |