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.