Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel spreadsheet do an automatic spell check
how can I set the spreadsheet to do an automatic spell check on closing
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel spreadsheet do an automatic spell check
In the 'BeforeClose' event of the 'ThisWorkbook' Module, put...
Private Sub Workbook_BeforeClose(Cancel As Boolean) Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", IgnoreUppercase:=False _ , AlwaysSuggest:=True, SpellLang:=1033 End Sub I used the macro recorder to decide on the Spelling Language of 1033. This is American English, General Style. HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "Ann Marie" wrote: how can I set the spreadsheet to do an automatic spell check on closing |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spell check and protection | Excel Discussion (Misc queries) | |||
Converter from MS Works 4.5 spreadsheet to MS Excel 2003 | Excel Discussion (Misc queries) | |||
Spell check a protected spreadsheet | Excel Discussion (Misc queries) | |||
How do I add a check box to an excel spreadsheet? | Excel Discussion (Misc queries) | |||
spell check protected document | Excel Discussion (Misc queries) |