G Guest Dec 30, 2003 #1 We need excel to run spell check automatically before the workbook can be saved. Any ideas how we can accomplish this?
We need excel to run spell check automatically before the workbook can be saved. Any ideas how we can accomplish this?
A Allan Koodray Dec 30, 2003 #2 -----Original Message----- We need excel to run spell check automatically before the Click to expand... workbook can be saved. Any ideas how we can accomplish this? . Create a Macro that fires off before close: Click to expand... Private Sub Workbook_BeforeClose(Cancel As Boolean) Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", IgnoreUppercase:=False _ , AlwaysSuggest:=True, SpellLang:=1033 End Sub The macro should be contained in the "This Workbook" Object. Allan Koodray
-----Original Message----- We need excel to run spell check automatically before the Click to expand... workbook can be saved. Any ideas how we can accomplish this? . Create a Macro that fires off before close: Click to expand... Private Sub Workbook_BeforeClose(Cancel As Boolean) Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", IgnoreUppercase:=False _ , AlwaysSuggest:=True, SpellLang:=1033 End Sub The macro should be contained in the "This Workbook" Object. Allan Koodray
