| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automate Spell Check
Is there a way to have Spell Check run when you close the workbook, similar
to having it run when you click send on an email? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automate Spell Check
That would take a Workbook Before Close, or Before Save macro.......if that
is what you want, post back and someone will help Vaya con Dios, Chuck, CABGx3 "Gary" wrote: Is there a way to have Spell Check run when you close the workbook, similar to having it run when you click send on an email? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automate Spell Check
Yes, please. Whatever anyone can help with.
This is for a file that always goes to the customer and we've been embarrassed a bit lately. "CLR" wrote: That would take a Workbook Before Close, or Before Save macro.......if that is what you want, post back and someone will help Vaya con Dios, Chuck, CABGx3 "Gary" wrote: Is there a way to have Spell Check run when you close the workbook, similar to having it run when you click send on an email? Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automate Spell Check
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", IgnoreUppercase:=False _ , AlwaysSuggest:=True End Sub Vaya con Dios, Chuck, CABGx3 "Gary" wrote: Yes, please. Whatever anyone can help with. This is for a file that always goes to the customer and we've been embarrassed a bit lately. "CLR" wrote: That would take a Workbook Before Close, or Before Save macro.......if that is what you want, post back and someone will help Vaya con Dios, Chuck, CABGx3 "Gary" wrote: Is there a way to have Spell Check run when you close the workbook, similar to having it run when you click send on an email? Thanks. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automate Spell Check
I right-clicked on the tab, clicked View Code, and placed it there. However,
nothing happens even when I know there are mispellings. Any ideas? "CLR" wrote: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", IgnoreUppercase:=False _ , AlwaysSuggest:=True End Sub Vaya con Dios, Chuck, CABGx3 "Gary" wrote: Yes, please. Whatever anyone can help with. This is for a file that always goes to the customer and we've been embarrassed a bit lately. "CLR" wrote: That would take a Workbook Before Close, or Before Save macro.......if that is what you want, post back and someone will help Vaya con Dios, Chuck, CABGx3 "Gary" wrote: Is there a way to have Spell Check run when you close the workbook, similar to having it run when you click send on an email? Thanks. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automate Spell Check
Hi Gary.....
It goes in the "This Workbook" module, not a "Sheet " Module..........if you would like it in a Sheet Module, then you could use this one to activate each time you switched away from that sheet. Private Sub Worksheet_Deactivate() Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", _ IgnoreUppercase:=False _ , AlwaysSuggest:=True End Sub Vaya con Dios, Chuck, CABGx3 "Gary" wrote: I right-clicked on the tab, clicked View Code, and placed it there. However, nothing happens even when I know there are mispellings. Any ideas? "CLR" wrote: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", IgnoreUppercase:=False _ , AlwaysSuggest:=True End Sub Vaya con Dios, Chuck, CABGx3 "Gary" wrote: Yes, please. Whatever anyone can help with. This is for a file that always goes to the customer and we've been embarrassed a bit lately. "CLR" wrote: That would take a Workbook Before Close, or Before Save macro.......if that is what you want, post back and someone will help Vaya con Dios, Chuck, CABGx3 "Gary" wrote: Is there a way to have Spell Check run when you close the workbook, similar to having it run when you click send on an email? Thanks. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automate Spell Check
Thanks. Working fine.
I appreciate the help. "CLR" wrote: Hi Gary..... It goes in the "This Workbook" module, not a "Sheet " Module..........if you would like it in a Sheet Module, then you could use this one to activate each time you switched away from that sheet. Private Sub Worksheet_Deactivate() Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", _ IgnoreUppercase:=False _ , AlwaysSuggest:=True End Sub Vaya con Dios, Chuck, CABGx3 "Gary" wrote: I right-clicked on the tab, clicked View Code, and placed it there. However, nothing happens even when I know there are mispellings. Any ideas? "CLR" wrote: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", IgnoreUppercase:=False _ , AlwaysSuggest:=True End Sub Vaya con Dios, Chuck, CABGx3 "Gary" wrote: Yes, please. Whatever anyone can help with. This is for a file that always goes to the customer and we've been embarrassed a bit lately. "CLR" wrote: That would take a Workbook Before Close, or Before Save macro.......if that is what you want, post back and someone will help Vaya con Dios, Chuck, CABGx3 "Gary" wrote: Is there a way to have Spell Check run when you close the workbook, similar to having it run when you click send on an email? Thanks. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automate Spell Check
You're welcome............thanks for the feedback.
Merry Christmas to you and yours.......... Vaya con Dios, Chuck, CABGx3 "Gary" wrote: Thanks. Working fine. I appreciate the help. "CLR" wrote: Hi Gary..... It goes in the "This Workbook" module, not a "Sheet " Module..........if you would like it in a Sheet Module, then you could use this one to activate each time you switched away from that sheet. Private Sub Worksheet_Deactivate() Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", _ IgnoreUppercase:=False _ , AlwaysSuggest:=True End Sub Vaya con Dios, Chuck, CABGx3 "Gary" wrote: I right-clicked on the tab, clicked View Code, and placed it there. However, nothing happens even when I know there are mispellings. Any ideas? "CLR" wrote: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", IgnoreUppercase:=False _ , AlwaysSuggest:=True End Sub Vaya con Dios, Chuck, CABGx3 "Gary" wrote: Yes, please. Whatever anyone can help with. This is for a file that always goes to the customer and we've been embarrassed a bit lately. "CLR" wrote: That would take a Workbook Before Close, or Before Save macro.......if that is what you want, post back and someone will help Vaya con Dios, Chuck, CABGx3 "Gary" wrote: Is there a way to have Spell Check run when you close the workbook, similar to having it run when you click send on an email? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spell Check | New Users to Excel | |||
| Spell Check | Excel Worksheet Functions | |||
| Spell check | Excel Discussion (Misc queries) | |||
| Spell check | Excel Worksheet Functions | |||
| ... Can I set Spell Check to automatically check my spelling ... | Setting up and Configuration of Excel | |||
Linear Mode
