how do I stop pop-up message after spell check
 

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

how do I stop pop-up message after spell check
 

See the response I gave to your last post.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

"elittos" wrote in message
...
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)?

how do I stop pop-up message after spell check
 

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

In article ,
says...
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)?