Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Spell Check Macro - Move to Cell
I am using the below macro to spell check a protected worksheet...
I noticed that when suggesting a word, it doesn't move to the cell where the misspelled word is located, like the built in menu item does... any way to make it work that way? Sub SpellCheck() ActiveSheet.Unprotect Password:="Password" Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", _ IgnoreUppercase:=False, AlwaysSuggest:=True ActiveSheet.Protect Password:="", DrawingObjects:=True, _ Contents:=True, Scenarios:=True _ , AllowFormattingCells:=True, AllowSorting:=True, AllowFiltering:=True End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I disable spell check in email sent from Excel macro | Excel Programming | |||
Macro to allow spell check with protect sheet | Excel Programming | |||
Error Msg 400 - Macro Spell Check | Excel Discussion (Misc queries) | |||
Spell Check range and move to active cells | Excel Programming | |||
Spell Check Macro Help | Excel Programming |