how do I stop pop-up message after spell check

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)?
 
T

Tushar Mehta

(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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

disable spell check pop-up message 3
Pasted text will not spell check 5
send email without spell check 0
Spell check 6
Spell checking textbox on a userform 10
Spell Check 2
Spell Check Entire WorkBook 1
Spell check on access with out message box 3

Top