how do I stop pop-up message after spell check

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a macro to spell check a selected range within a worksheet.
After the range selection, I am running ActiveCell.CheckSpelling. Since I am
not checking the spelling of the entire worksheet, the user is prompted with
a message asking them if they want to continue Spell Check from the
beginning. Is there anyway to disable this pop-up (without running spell
check on the entire worksheet)?
 
(e-mail address removed) asked the same question four minutes
ago!

Hopefully, he will check this discussion.

Application.DisplayAlerts = False
Selection.CheckSpelling
Application.DisplayAlerts = True

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top