macro to spellcheck entire workbook

E

Excel-lent

Does anyone have a macro for Excel 2000 that spellchecks
an entire workbook (ie - selects all worksheets, performs
spellcheck, then returns to only one worksheet selected)?
Is this possible? The excel workbooks I have all have
differently named worksheets.

Thanks for any help you might be able to provide.
 
N

Norman Jones

Hi Excel-lent,

Try:

Sub Tester()
Dim WS As Worksheet
For Each WS In ActiveWorkbook.Worksheets
WS.Cells.CheckSpelling
Next WS

End Sub
 
C

Charles

Excel-Lent,

This is a recored macro it should help


Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC",
IgnoreUppercase:=False _
, AlwaysSuggest:=True, SpellLang:=1033


Charles
 
Top